How to increase connction string in my postgresql database

kaaancan
PRO

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


kaaancan
PRO

a year ago

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


kaaancan
PRO

a year ago

I added concurrency and the database connection timeouts


kaaancan
PRO

a year ago

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?


kaaancan
PRO

a year ago

And latency is very important for my usecase


kaaancan
PRO

a year ago

Oh i see, let me take a look into that


a year ago


kaaancan
PRO

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


kaaancan
PRO

a year ago

Thanks, will research on my own


How to increase connction string in my postgresql database - Railway Help Station