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@xxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general