tyler
Explore posts from serversPPrisma
•Created by tyler on 2/5/2025 in #help-and-questions
PgBouncer and Prisma
hi! if my db has a 500 connection limit and i'm using pgbouncer in between, with prisma, what should the connection_limit be set to in my db string? i see these strange spikes where queries suddenly start taking much, much, longer and the database is not struggling nor is the application code.
my hunch is that prisma connections are somehow backing up / not being freed up correctly and it's leading to a backed up queue.
any guidance here would be greatly appreciated.
p.s. this has been an issue for us for a long, long, long time and i just added pgbouncer to the mix which seems to help a bit, but still happens about once an hour.
22 replies