Thread: How many connections can a Postgress database support...
How many connections can a Postgres database support and how do you set this parameter. Is there some sort of multithreading in Postgres and how do you implement it.
Thanks,
Graham
--- Graham Bartlett <gbartlett@gamet.com> wrote: > How many connections can a Postgres database support > and how do you set > this parameter. Is there some sort of multithreading > in Postgres and how > do you implement it. You can set the maximum number of concurrent connection by editing the section MAX_CONNECTION in postgresql.conf. Postgres will fork a new process whenever there is a new client connection to the database. best regards, ludwig. __________________________________________________ Do you Yahoo!? New DSL Internet Access from SBC & Yahoo! http://sbc.yahoo.com
On Wed, 11 Dec 2002 12:33 am, you wrote: > How many connections can a Postgres database support and how do you set > this parameter. Is there some sort of multithreading in Postgres and how > do you implement it. That's either up to you or up to your hardware. The "max connections" is specified in postgresql.conf. The default is 64. I don't know if there is a hard limit. sol > > > > Thanks, > > Graham