Search Postgresql Archives

Re: Why i see several postgres server processes sometimes ?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux