Re: BUG #1707: statistics collector starts with stats_start_collector - Mailing list pgsql-bugs

From Bruce Momjian
Subject Re: BUG #1707: statistics collector starts with stats_start_collector
Date
Msg-id 200506140308.j5E38Hk18453@candle.pha.pa.us
Whole thread Raw
In response to Re: BUG #1707: statistics collector starts with stats_start_collector = false  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: BUG #1707: statistics collector starts with stats_start_collector
List pgsql-bugs
Tom Lane wrote:
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > Tom Lane wrote:
> >> I don't have a problem with removing it as a writable option ... but
> >> I'm thinking we should leave it as a read-only GUC parameter (like
> >> the several others we have already).  Otherwise we'll need to add some
> >> other method of finding out whether the collector is running.
>
> > Why would a user care?
>
> luser> It's not collecting statistics!
>
> us> Is the collector running?
>
> luser> How should I know?
>
> us> er ...
>
> If we don't have a way to check this, we'll regret it soon enough...
> now maybe a GUC setting isn't the optimal way, but I think we need
> *some* way besides ps.  ps doesn't work remotely and I think there's
> no simple equivalent under Windows either.

Sure, but the GUC only reports that it thinks the stats collector
started, not whether it is running or not.  I think 'ps' is a fine way
to tell.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-bugs by date:

Previous
From: Klint Gore
Date:
Subject: Re: BUG #1698: Different behavior in UNIQUE and DISTINCT
Next
From: Andreas Pflug
Date:
Subject: Re: BUG #1707: statistics collector starts with stats_start_collector