Re: There are many processes created and died frequently during PostgreSQl idle

Поиск
Список
Период
Сортировка
От Amit Langote
Тема Re: There are many processes created and died frequently during PostgreSQl idle
Дата
Msg-id CA+HiwqGNTh4UQ-k+Mvp9SLXgkuBcsumRELsB2STxWFH7PMrTyQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: There are many processes created and died frequently during PostgreSQl idle  (高健 <luckyjackgao@gmail.com>)
Список pgsql-general
On Mon, May 27, 2013 at 10:56 AM, 高健 <luckyjackgao@gmail.com> wrote:
> Hi:
> Thanks for Jov's reply.
> I traced it again, and found they are really for autovacuum.
> I found that
> some will call proc_exit() from within  AutoVacLauncherMain function,
> some will call proc_exit() from within AutoVacWorkerMain function.
>
> But I wonder why not using only a few daemon , instead of  making those
> processes be short life.

The short lived processes are autovacuum "worker" processes which need
to exit as soon as their work is done. There does exist a daemon
called autovacuum launcher, which periodically forks autovacuum worker
processes to perform vacuum activity. You might want to read more
about them here:

http://www.postgresql.org/docs/9.2/static/routine-vacuuming.html#AUTOVACUUM

--
Amit Langote


В списке pgsql-general по дате отправления:

Предыдущее
От: 高健
Дата:
Сообщение: Re: There are many processes created and died frequently during PostgreSQl idle
Следующее
От: Ash Damle
Дата:
Сообщение: Human readable or full text of xlog (pg_xlog) for vs 9.2