Efficient database connection pool configs
Learn how to utilize PgBouncer to improve the performance of your Django applications by managing database connections efficiently.
This article explores the differences between transaction pooling and session pooling in PgBouncer, highlighting their advantages and use cases.
This article addresses common issues with prepared statements in PgBouncer when using JDBC, particularly focusing on pooling modes.
Tuned postgresql.conf settings for a dedicated 8-core / 32 GB RAM database server. Covers shared buffers, WAL, autovacuum, parallel query and connection settings - with explanations for each knob.