AnalyticDB for PostgreSQL is built based on PostgreSQL and supports the mainstream connection pools PgBouncer and pgool-II. Appropriate connection pool software can improve database performance and scalability, reduce database workloads, and provide better connection management and troubleshooting capabilities.
PgBouncer: supports the database connection pool feature to allow you to manage and reuse database connections, reduce connection overheads between applications and databases, and improve the system concurrency performance. For more information, see PgBouncer.
pgpool-II: supports the database connection pool feature to allow you to implement load balancing, automatic retries, and query cache. For more information, see pgpool-II.