cesar sampaio
cesar sampaio
PostsComments
PPrisma
Created by cesar sampaio on 9/26/2024 in #help-and-questions
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`,
    },
  },
}
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`,
    },
  },
}
5 replies