Stage:
General Availability
Available on self-hosted:
Yes
Every project on Micro Compute and above includes a dedicated PgBouncer instance co-located with your database. Dedicated Poolers work alongside Supavisor as an alternative connection pooling option, providing IPv4 compatibility and prepared statement support.
Key benefits
- IPv4 compatibility: Unlike Supavisor's transaction mode, Dedicated Poolers support IPv4 connections.
- Prepared statements: Full support for prepared statements, not available in Supavisor transaction mode.
- Flexible pooler selection: Swap between Supavisor and PgBouncer pooler types based on your needs.
- Independent connection limits: Each pooler has its own client connection limits.
- Shared pool sizing: Both poolers share the same pool size setting but operate independently.
- Maximum performance: Co-located with your database for minimal latency.
Dedicated Poolers are valuable for:
- Applications requiring IPv4 compatibility
- Workloads using prepared statements
- Projects needing dedicated connection pooling resources
- High-performance applications requiring co-located infrastructure
Dedicated Poolers provide an alternative to Supavisor for specific use cases, giving you maximum flexibility in how you manage database connections.