2 years 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 ?
12 Replies
2 years 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
2 years 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
2 years ago
right but would this be a better usecase for pgbouncer?
2 years 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 ?
2 years ago
i think theres some config needed, im not an expert on this topic though