Re: PostgreSQL - Debian - Processes: postgres: writer process, etc. - Mailing list pgsql-novice

From Jean-Yves F. Barbier
Subject Re: PostgreSQL - Debian - Processes: postgres: writer process, etc.
Date
Msg-id 20120130115441.0ac4cb39@anubis.defcon1
Whole thread Raw
In response to PostgreSQL - Debian - Processes: postgres: writer process, etc.  (Windybell <lmhelp1@orange.fr>)
Responses Re: PostgreSQL - Debian - Processes: postgres: writer process, etc.  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: PostgreSQL - Debian - Processes: postgres: writer process, etc.  (Windybell <lmhelp1@orange.fr>)
List pgsql-novice
On Mon, 30 Jan 2012 02:24:08 -0800 (PST)
Windybell <lmhelp1@orange.fr> wrote:

> I am running the Debian Lenny PostgreSQL package (v.8.4).
> When I issue the following command:

I guess the command is: ps axuf|grep postgres

> I am wondering what are these four last processes ("postgres: writer",
> "postgres: wal writer", "postgres: autovacuum launcher" and "postgres: stats
> collector")?

Because, as their name suggest it, they take care of Pg different
parts.

> Their PPID is 3069.

That can't be, each running software/process have a different PID.
This PID Nb is in the 2nd column.

> What is weird to me is the "COMMAND" column as far as these four processes
> are concerned.
> In the "COMMAND "column I would expect a real command, not a description.
> Can you explain?

If you use the command I wrote above, you'll see they all depend on
the main process launch by the script in /etc/init.d.

--
Eat shit -- billions of flies can't be wrong.

pgsql-novice by date:

Previous
From: Windybell
Date:
Subject: PostgreSQL - Debian - Processes: postgres: writer process, etc.
Next
From: Tom Lane
Date:
Subject: Re: Where do my local data bases go?