Re: Beginner optimization questions, esp. regarding Tsearch2

From: Markus Schaber <schabi(at)logix-tt(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Cc: Carl Youngblood <carl(at)youngbloods(dot)org>
Subject: Re: Beginner optimization questions, esp. regarding Tsearch2
Date: 2006-08-10 11:07:08
Message-ID: 44DB135C.8080705@logix-tt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi, Richard and Carl,

Richard Huxton wrote:
> Carl Youngblood wrote:
>> - I noticed that there are six different postmaster daemons running.
>> Only one of them is taking up a lot of RAM (1076m virtual and 584m
>> resident). The second one is using 181m resident while the others are
>> less than 20m each. Is it normal to have multiple postmaster
>> processes?
>
> You should have one master backend process and one per connection. PG is
> a classic multi-process designed server.

There may be some additional background processes, such as the
background writer, stats collector or autovacuum, depending on your
version and configuration.

HTH,
Markus

--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Michael Stone 2006-08-10 11:09:38 Re: Postgresql Performance on an HP DL385 and
Previous Message Phil Cairns 2006-08-10 10:00:38 Slow access to PostgreSQL server