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

2013-05-26 Thread Amit Langote
On Mon, May 27, 2013 at 10:56 AM, 高健 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. > >

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

2013-05-26 Thread 高健
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

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

2013-05-23 Thread Jov
the process you see may be autovacuum worker process,you can tune the log_autovacuum_min_duration to log the autovacuum activities and check if the pids match http://www.postgresql.org/docs/9.2/static/runtime-config-autovacuum.html 2013/5/24 高健 > Hello all: > > I found that during postgresql

[GENERAL] There are many processes created and died frequently during PostgreSQl idle

2013-05-23 Thread 高健
Hello all: I found that during postgresql running, there are so many processes being created and then died. I am interested in the reason. Here is the detail: I installed from postgresql-9.2.1.tar.bz2. I put some debug code in fd.c 's PathNameOpenFile function: fprintf(stderr,"+++While Calling