Pelin
Which PgBouncer pooling mode should I pick — Session, Transaction, or Statement?
Pick Transaction mode for a web fleet; the price is protocol-level prepared statements, so disable them in the app or turn on PgBouncer 1.21+ support.
All questions
Tag
#PostgreSQL
The PostgreSQL database: index strategies, the query planner, vacuum and performance. Questions under this tag, answered directly. (Page 2/2)
12 answered questions carry this tag.
Doğa
How do I choose the right composite index column order in PostgreSQL?
Build one (user_id, status, created_at DESC) index with equality columns first and the sort column last, then drop the single-column indexes it now covers.