Re: Postgres memory question

From: Rainer Bauer <usenet(at)munnin(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Postgres memory question
Date: 2009-08-09 22:19:20
Message-ID: rkiu75l98q761apujg6tn8td0npldi7e3g@4ax.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Kobus Wolvaardt schrieb:

>We have software deployed on our network that need postgres, we have server
>that hosts the server and all worked fine until we crossed about 200 users.
>The application is written so that it makes a connection right at the start
>and keeps it alive for the duration of the app. The app is written in
>Delphi. The postgres server runs on a windows 2008 server with quad core cpu
>and 4 GB of ram.

Have you tried to increase Desktop Heap as described here:
<http://wiki.postgresql.org/wiki/Running_%26_Installing_PostgreSQL_On_Native_Windows#I_cannot_run_with_more_than_about_125_connections_at_once.2C_despite_having_capable_hardware>

Rainer

In response to

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2009-08-09 22:37:44 Re: Postgres memory question
Previous Message Magnus Hagander 2009-08-09 19:10:48 Re: Re: PG fails on Windows Server 2008: could not reattach to shared memory ... : 487