Skip site navigation (1) Skip section navigation (2)

Re: rebellious pg stats collector (reopened case)

From: Laszlo Nagy <gandalf(at)shopzeus(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-admin(at)postgresql(dot)org
Subject: Re: rebellious pg stats collector (reopened case)
Date: 2008-12-30 13:17:01
Message-ID: 495A1F4D.6050205@shopzeus.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-performance
> alive".  Otherwise you'll have trouble with the collector not stopping
> when you want it to.  Look into src/backend/storage/ipc/pmsignal.c:
>
> -		return (getppid() == PostmasterPid);
> +		return (getppid() != 1);
>
> (Obviously this is a hack, but it should work on any Unixish system)
>   
Thanks. I'm going to try this next weekend (when nobody works on the 
database) and come back with the results.

In response to

Responses

pgsql-performance by date

Next:From: Robert HaasDate: 2008-12-30 14:43:28
Subject: Re: Big index sizes
Previous:From: Anton BogdanovitchDate: 2008-12-30 10:41:42
Subject: perform 1 check vs exception when unique_violation

pgsql-admin by date

Next:From: Peter EisentrautDate: 2008-12-30 13:55:43
Subject: Re: postgres block_size problem
Previous:From: Bhujbal, SantoshDate: 2008-12-30 12:28:15
Subject: postgres block_size problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group