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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-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

Browse pgsql-admin by date

  From Date Subject
Next Message Peter Eisentraut 2008-12-30 13:55:43 Re: postgres block_size problem
Previous Message Bhujbal, Santosh 2008-12-30 12:28:15 postgres block_size problem

Browse pgsql-performance by date

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