4 ms·
I’m thinking can just use :erlang.phash2 to pin a client connection process to a db connection process. The only thing is a slow query could block a db connecti
by chasers 3y ago
I’m thinking can just use :erlang.phash2 to pin a client connection process to a db connection process. The only thing is a slow query could block a db connection for others pinned to it.
- phamilton 3y agoInteresting approach, but that would be messy when multiple instances of an application all try to prepare the same query with the same name on the same server connection. Clients would need to know that an "prepared statement with that name already exists" error is ok and they should go ahead and execute it. Should we take this discussion into a GitHub issue?
- chasers 3y agoFor sure > https://github.com/supabase/supavisor/issues/69 https://github.com/supabase/supavisor/issues/69