Re: PostgreSQL - Debian - Processes: postgres: writer process, etc.

Поиск
Список
Период
Сортировка
От Jean-Yves F. Barbier
Тема Re: PostgreSQL - Debian - Processes: postgres: writer process, etc.
Дата
Msg-id 20120130115441.0ac4cb39@anubis.defcon1
обсуждение исходный текст
Ответ на PostgreSQL - Debian - Processes: postgres: writer process, etc.  (Windybell <lmhelp1@orange.fr>)
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: Windybell
Дата:
Сообщение: PostgreSQL - Debian - Processes: postgres: writer process, etc.
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Where do my local data bases go?