Supabase Introduces PgBouncer for Connection Pooling

Supabase has added PgBouncer as a connection pooler for more efficient Postgres database connections.

Connection pooling helps manage connections to the Postgres database, keeping them open and available for multiple requests, which is beneficial especially in serverless environments.

PgBouncer helps to handle surges in connections by reusing available connections, queuing extra requests instead of rejecting them, thus allowing the database to handle more load.

New projects on Supabase will automatically include connection pooling, with a new section for it in the dashboard and different pool modes available: Session, Transaction, and Statement.

Future plans include exposing more PgBouncer settings to the UI and bringing the latest version of Supabase Postgres to AWS and Digital Ocean marketplaces.