PostgresSQL 9.0 64 bit on windows 2008 64bit
Hi
We currently use postgres 8.3 on windows 2008 32bit
With max_connections set to 1000
Since we have more than 125 connections, we run postgres as a stand alone process instead of as a service.
http://wiki.postgresql.org/wiki/Running_&_Installing_PostgreSQL_On_Native_Windows#I_cannot_run_with_more_than_about_125_connections_at_once.2C_despite_having_capable_hardware
Now when we are upgrading to Windows 2008 64bit running PostgreSQL 9 64 bit.
Can we run it as a service even though we have max_connections set to 1000 or do we have to run it as a stand alone process?
Is there an upper max_connection that isn't good to pass, when running on windows,
Say that I would set max_connection to 5000 and then have 5000 postgres processes running on the server, is that wise?
Must each connection have to start a new process?
I guess we should look at pgBouncer (actually we have looked at it but it's not in use right now)
Thanks
/Niklas
On Tue, Feb 15, 2011 at 12:50, Niklas Langvig
<niklas.langvig@globesoft.com> wrote:
Hi
We currently use postgres 8.3 on windows 2008 32bit
With max_connections set to 1000
Wow. That's really not good for performance on Windows..
Since we have more than 125 connections, we run postgres as a stand alone
process instead of as a service.Now when we are upgrading to Windows 2008 64bit running PostgreSQL 9 64 bit.
Can we run it as a service even though we have max_connections set to 1000
or do we have to run it as a stand alone process?
AFAIK, it should work, but I don't think anybody has done any kind of
benchmark to figure out where the limit is at now.
Say that I would set max_connection to 5000 and then have 5000 postgres
processes running on the server, is that wise?
No. And the same definitely goes for 1000. It works, but it's not wise.
Must each connection have to start a new process?
Yes.
I guess we should look at pgBouncer (actually we have looked at it but it’s
not in use right now)
If you can use that, or application level connection pooling, you will
likely get much better performance.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/