| From: | Raymond O'Donnell <rod(at)iol(dot)ie> |
|---|---|
| To: | "Massa, Harald Armin" <chef(at)ghum(dot)de> |
| Cc: | Peter Geoghegan <peter(dot)geoghegan86(at)gmail(dot)com>, Georgi Ivanov <georgi(dot)r(dot)ivanov(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Why i see several postgres server processes sometimes ? |
| Date: | 2010-10-06 18:40:29 |
| Message-ID: | 4CACC29D.7030502@iol.ie |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)iol(dot)ie
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mathieu De Zutter | 2010-10-06 19:26:30 | Re: Idle connections |
| Previous Message | Massa, Harald Armin | 2010-10-06 17:53:38 | Re: Why i see several postgres server processes sometimes ? |