Re: Controlling proliferation of postgres.exe processes - Mailing list pgsql-general

From Alan Hodgson
Subject Re: Controlling proliferation of postgres.exe processes
Date
Msg-id 200906231505.03777@hal.medialogik.com
Whole thread Raw
In response to Controlling proliferation of postgres.exe processes  (Radcon Entec <radconentec@yahoo.com>)
List pgsql-general
On Tuesday 23 June 2009, Radcon Entec <radconentec@yahoo.com> wrote:
> Greetings!
>
> At the current moment, our customer's computer has 22 instances of
> postgres.exe running.  When a colleague checked a few minutes ago, there
> were 29.  Our contract specifies that we cannot consume more than 40% of
> the computer's memory, and we're over that level.  When does an instance
> of postgres.exe get created, and how can we make sure we create only the
> minimum number necessary?
>

Most of the memory reported in use by PostgreSQL is shared ... the actual
per-process memory use is fairly low unless your work_mem is set  high and
you have queries that use it.



pgsql-general by date:

Previous
From: Greg Stark
Date:
Subject: Re: Controlling proliferation of postgres.exe processes
Next
From: Craig Ringer
Date:
Subject: Re: Replication