Re:Gracefully Scaling to 10k PostgreSQL Connections for $35/...
by merb on Wednesday June 27, 2018 @02:59PM
(#17410810)
well transaction pooling is good for most databases.
consider having 10 upstream connections per transaction pool and 10000s of connections to applications.
pgbouncer can handle that and every application would only be assigned to a real database if a transaction/query happens and after that the upstream connection would be deassigned.
consider having 10 upstream connections per transaction pool and 10000s of connections to applications. pgbouncer can handle that and every application would only be assigned to a real database if a transaction/query happens and after that the upstream connection would be deassigned.