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.