PrismaP
Prisma16mo ago
4 replies
cesar sampaio

How to kill idle connections properly in postgres

Prisma has been creating too many connections on my app.

I have this:

export const prismaOptions: Prisma.Subset<
  Prisma.PrismaClientOptions,
  Prisma.PrismaClientOptions
> = {
  errorFormat: 'pretty',
  // log: ['info', 'query'],
  datasources: {
    db: {
      url: `${process.env.DATABASE_URL}?connection_limit=500&pool_timeout=0`,
    },
  },
}
Was this page helpful?