a year ago
Hey is there an easy way to quickly increase the max_connections of my postgresql service ? Or do i need to ssh into the container and adjust the config ?
0 Replies
a year ago
a few things first
railway does not provide ssh access
yes there is a very easy way to up the connection limit
but more importantly, why do we need to up the connection limit? the default is 100
a year ago
n/a
I have a usecase where i need to insert/retrieve a lot of information in 5 minutes.
Its an AI usecase where i create and manipulate a lot of data
I dont really care about pricing or anything as long as the database has a good performance
a year ago
right but would this be a better usecase for pgbouncer?
a year ago
Thanks, just quickly ChatGPTed pgbounder. Do you know if i need to adjust anything on prisma side or can i just point it to pgBouncer ?
a year ago
i think theres some config needed, im not an expert on this topic though