| From: | Amit Langote <amitlangote09(at)gmail(dot)com> |
|---|---|
| To: | 高健 <luckyjackgao(at)gmail(dot)com> |
| Cc: | Jov <amutu(at)amutu(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: There are many processes created and died frequently during PostgreSQl idle |
| Date: | 2013-05-27 02:22:36 |
| Message-ID: | CA+HiwqGNTh4UQ-k+Mvp9SLXgkuBcsumRELsB2STxWFH7PMrTyQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, May 27, 2013 at 10:56 AM, 高健 <luckyjackgao(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ash Damle | 2013-05-27 02:27:09 | Human readable or full text of xlog (pg_xlog) for vs 9.2 |
| Previous Message | 高健 | 2013-05-27 01:56:18 | Re: There are many processes created and died frequently during PostgreSQl idle |