Relative Content

Tag Archive for postgresqlprismapgbouncer

Prisma with postgresql + pgbouncer connection limit

I’m deploying a service that uses Prisma with postgresql and pgbouncer. What I would like to know is what to set the Prisma’s connection_limit url parameter to, given that my database supports only 22 connections and pgbouncer is configured to use 22 connections. Can the connection_limit parameter be greater than 22? I think connection_limit configures Prisma’s internal connection pool which in theory could be larger than what pgbouncer’s connection limit which would result in the connections being queued up by pgbouncer.