How to increase connction string in my postgresql database
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 ?
9 Replies
Project ID:
N/Aa 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
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 added concurrency and the database connection timeouts
I dont really care about pricing or anything as long as the database has a good performance
right but would this be a better usecase for pgbouncer?
And latency is very important for my usecase
Oh i see, let me take a look into that
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 ?
i think theres some config needed, im not an expert on this topic though
Thanks, will research on my own