Re: Beginner optimization questions, esp. regarding Tsearch2 - Mailing list pgsql-performance

From Markus Schaber
Subject Re: Beginner optimization questions, esp. regarding Tsearch2
Date
Msg-id 44DB135C.8080705@logix-tt.com
Whole thread Raw
In response to Re: Beginner optimization questions, esp. regarding Tsearch2  (Richard Huxton <dev@archonet.com>)
List 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

pgsql-performance by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Beginner optimization questions, esp. regarding Tsearch2
Next
From: Michael Stone
Date:
Subject: Re: Postgresql Performance on an HP DL385 and