PostgresSQL 9.0 64 bit on windows 2008 64bit

From: Niklas Langvig <niklas(dot)langvig(at)globesoft(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: PostgresSQL 9.0 64 bit on windows 2008 64bit
Date: 2011-02-15 11:50:37
Message-ID: F07D92605693874883FC5F6E4FB1A851058EAF9A70@Globe-Exch03.globesoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vick Khera 2011-02-15 13:48:10 Re: Using Bitmap scan instead of Seq scan
Previous Message Christian Ullrich 2011-02-15 09:45:02 Re: Multithreaded query onto 4 postgresql instances