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