Re: Why i see several postgres server processes sometimes ?

On 06/10/2010 18:53, Massa, Harald Armin wrote:
> Peter,
>
>     This is normal. Postgres is said to have a multi-process architecture
>     (which is often contrasted with a multi threaded architecture). The
>     number of processes isn't very predictable.
>
> you are right, it is normal.
>
> But the number of processes is quite predictable:
>
> on default PostgreSQL starts up with 5 processes:
>
> one background-writer
> one postmaster who masters the startup of additional progresses
> one autovacuum-daemon
> two processes which I have not leveled up enough to know what they are doing
> And then there is one additional process for every client connection.

So that's where the extra processes are coming from - something is
holding connections open.

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie