Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres memory question - Mailing list pgsql-general

From Rainer Bauer
Subject Re: Postgres memory question
Date
Msg-id rkiu75l98q761apujg6tn8td0npldi7e3g@4ax.com
Whole thread Raw
In response to Postgres memory question  (Kobus Wolvaardt <kobuswolf@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: Re: PG fails on Windows Server 2008: could not reattach to shared memory ... : 487
Next
From: John R Pierce
Date:
Subject: Re: Postgres memory question