4 ms·
Connections are pretty expensive in PG how can you do pooling if every user connects directly?
by conceptme 3y ago
Connections are pretty expensive in PG how can you do pooling if every user connects directly?
- giovannibonetti 3y agoConnection poolers like PgBouncer [1] (traditional) and Supabase's Supavisor [2] (new) come to mind. [1] https://www.pgbouncer.org/ https://www.pgbouncer.org/ [2] https://github.com/supabase/supavisor https://github.com/supabase/supavisor
- mike_hearn 3y agoSupavisor looks great. Unclear if it can be configured to use https://github.com/pgaudit/set_user https://github.com/pgaudit/set_user though. That said, there are quite a lot of CRUD apps in the world that don't need to support lots of simultaneous users, or where you can just add read replicas quite cheaply. Think internal apps, dashboards, etc.