3 ms·
All good tips! I never understood why pgbouncer wasn’t just included by default. Additionally, the linked article about checking for unused indexes is really h
by brightball 5y ago
All good tips! I never understood why pgbouncer wasn’t just included by default.
Additionally, the linked article about checking for unused indexes is really helpful IMO.
https://blog.crunchydata.com/blog/cleaning-up-your-postgres-database https://blog.crunchydata.com/blog/cleaning-up-your-postgres-...
- saurik 5y agoIt would be awkward if pgbouncer were "included" in postgres as the topology of bouncers you have might involve multiple layers running on different computers to minimize things like connection setup latency.
- brightball 5y agoThat makes sense. Never had to get into a layered bouncer setup, but I can imagine how that would happen.
- osigurdson 5y agoNote that LISTEN/NOTIFY only works with pgbouncer session pooling.