Prisma

How does connection pool work? If I have a postgres with 100 max_connections setting and pool size is set to 10, does it mean that I can only ever use 10 out 100 connections ? No right?

Yes. If you have 1 instance of your app running that uses Prisma Client with a connection pool size of 10, Prisma Client will use a maximum of 10 connections at a time to run queries in parallel.

<https://prisma.slack.com/archives/CA491RJH0/p1650229835526999>
&gt; Reason I am asking is lets say I want to run 10 SELECTS concurently through prisma how would that work?
If 1 request to your app does 10 concurrent SELECTs, that would indeed use all the connections in your pool already.