Conference Schedule - PGConf.EU 2019
PgBouncer and a Bit of Queueing Theory
Time: 09:30 - 10:20
You have a few thousand clients connecting to your database all at once, that might not go well. PgBouncer can help.
PgBouncer can restrict access to a database server to a configurable pool size and make excess clients wait in a queue for their turn. Can what works in the supermarket also work for your database, or will it just result in frustrated clients? What pool sizes, queue sizes, and timeouts will work? At what point do you have to consider other ways to scale? We'll work through some examples to analyze this. Then we'll consider some mathematics and queueing theory to think about this issue more generally. PgBouncer is but an example here; these concepts are applicable across the entire stack of scalable database applications.