Re: BUG #1707: statistics collector starts with stats_start_collector

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: BUG #1707: statistics collector starts with stats_start_collector
Дата
Msg-id 200506140308.j5E38Hk18453@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: BUG #1707: statistics collector starts with stats_start_collector = false  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: BUG #1707: statistics collector starts with stats_start_collector  (Andreas Pflug <pgadmin@pse-consulting.de>)
Список 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 по дате отправления:

Предыдущее
От: Klint Gore
Дата:
Сообщение: Re: BUG #1698: Different behavior in UNIQUE and DISTINCT
Следующее
От: Andreas Pflug
Дата:
Сообщение: Re: BUG #1707: statistics collector starts with stats_start_collector