Oliver Rice

Was able to get unblocked on this by uninstalling, deleting the `~/.pgx` directory, and re-installing ```shell cargo uninstall cargo-pgx rm -rf ~/.pgx cargo install cargo-pgx cargo pgx init ```

The issue appeared for me again after 1 successful run of `cargo pgx test` following re-install re-opening since ^ is experiencing it too

Here's what I ended up with after adapting the script [installcheck](https://github.com/zombodb/zombodb/blob/master/installcheck) script ```sh #! /bin/bash ######## # Vars # ######## TMPDIR="$(mktemp -d)" export PGDATA="$TMPDIR" export PGHOST="$TMPDIR" export PGUSER=postgres export PGDATABASE=postgres...

> Is this still an issue on recent MacOS with a recent PGX (like 0.4.x)? Also was this an M1 or x86-64 Mac? yes, I just hit it with an...

Subscription support is likely a ways off since postgres has no websocket support to piggyback on, but we do plan to explore it We have some ideas from supabase/realtime to...

Interactions between queries and role + row level security make subscriptions difficult to implement and cache securely [supabase/realtime](https://github.com/supabase/realtime) uses [supabase/walrus](https://github.com/supabase/walrus) to solve those interactions efficiently but it is tightly coupled....

sure thing, The [supabase/walrus](https://github.com/supabase/walrus/tree/worker/worker) work is on the linked branch. Currently [supabase/realtime](https://github.com/supabase/realtime) does a kind-of smart polling thing to query Postgres for new WAL records. The walrus worker branch extracts...

Thank you for providing such complete stats, that's great context Everything in your queries looks pretty reasonable. pg_graphql does use a prepared statement cache which may account for a small...

Interesting that CPU is an issue with such a small data set. I'm not sure what would cause that The best way to get at the SQL query is to...

> I presume that removing parts like true = true actually does nothing as it's likely already optimised out that's correct. Scalar statements are either completely removed or executed exactly...