Thread: what the initial 3 daemon of postmaster process do?

what the initial 3 daemon of postmaster process do?

From
Dohyung Kim
Date:
Hi All,

After fist installation, using pg_ctl script, and starting postmaster process.
3 of processes as its initial daemon are on in the unix system memory which is
able to see by 'ps -ef|grep postmaster'.

like to get information about the reason belows.
1. why 3 daemon processes start in its starting point
2. what the roles of each 3 daemon processes are
3. and how can I control the initial number of daemon process.

like to also confirm whether the count of postmaster process that is up in the run time
increases or decreases according to the client-request, that is, the DB transaction.


regards, Dohyung Kim

Re: what the initial 3 daemon of postmaster process do?

From
Tom Lane
Date:
Dohyung Kim <dh2002.kim@samsung.com> writes:
> 1. why 3 daemon processes start in its starting point
> 2. what the roles of each 3 daemon processes are

Postmaster, statistics collector, and statistics buffer process.

> 3. and how can I control the initial number of daemon process.

You can't (other than by choosing to disable statistics collection,
in which case the two stats processes won't run).

            regards, tom lane