No video of the event yet, sorry!
Using database connection pooling is a common take for addressing the problem of handling of a large set of requests, without affecting the overall throughput of a cluster or database. This talk will show the importance of its setup and some advanced techniques for handling active connections and pools in production. Particularly, vanilla Postgres architecture is robust, but non-persistent connections on scale do not tend to work at fully potential as other engines can handle. At some point, pools can save costs but sometimes can also not be suitable, which will be discussed on the talk.
Some of the pooling tools that will be under the scope are PgBouncer, Odyssey and PgPool.
- 2019 June 21 - 12:30
- 50 min
- PostgreSQL Ibiza
- Track 1
- Periods and System-Versioned Tables
- Start Time:
- 2019 June 21 12:30