Re: Configuration of statistical views - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Configuration of statistical views
Date
Msg-id 14538.993837499@sss.pgh.pa.us
Whole thread Raw
In response to Re: Configuration of statistical views  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Configuration of statistical views  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: Configuration of statistical views  (Jan Wieck <JanWieck@Yahoo.com>)
Re: Configuration of statistical views  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> writes:
>> If  somebody  wants  to  see  an applications querystring (at
>> least the first 512 bytes) just in case something goes  wrong
>> and  the client hangs, he'd have to run querystring reporting
>> all the time either way.

> Agreed.  That should be on all the time.

"On by default", sure.  "On all the time", I'm not sold on.

But anyway, we seem to be converging on the conclusion that setting
up a GUC variable will do fine, at least until there is definite
evidence that it won't.

Probably there need to be at least 2 variables: (a) a PGC_POSTMASTER
variable that controls whether the stats collector is even started,
and (b) PGC_USERSET variable(s) that enable a particular backend to
send particular kinds of data to the collector.  Note that, for example,
backend start/stop events probably need to be reported whenever the
postmaster variable is set, even if all the USERSET variables are off.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Manuel Sugawara
Date:
Subject: Re: Re: Postgres to Dia UML
Next
From: Tom Lane
Date:
Subject: Re: Configuration of statistical views