We are using Prisma in serverless on GCP, the serverless currently configured with 4 CPUs, hence making Prisma setting the connection pool to
9
9
by default. This low amount of connection pool making our application very slow, espacially because we currently have only one instance of our backend.
I tried to increase the amount of connection pool by setting
connection_limit=50
connection_limit=50
, it worked locally yesterday but now it seems to not work. When I tried to deploy it to one of our cloud environment it did not work at all. I logged the amount of connection pool Prisma instantiated with, it always set to
21
21
in my MacBook Pro. What am I missing? Our DB is PostgreSQL