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

From Bruce Momjian
Subject Re: Configuration of statistical views
Date
Msg-id 200106291621.f5TGL5v28435@candle.pha.pa.us
Whole thread Raw
In response to Re: Configuration of statistical views  (Jan Wieck <JanWieck@Yahoo.com>)
List pgsql-hackers
> Bruce Momjian wrote:
> > >     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.
> >
> > >     So I can see value in a per database default  in  pg_database
> > >     plus the ability to switch it on/off via statement to analyze
> > >     single commands.
> >
> > Sounds fine.  You may be able to just to a GUC/SET option and not do a
> > per-database field.  GUC doesn't do per-database and having a database
> > flag and GUC would be confusing.  Let's roll with just GUC/SET and see
> > how it goes.
> 
>     No  per  backend  on/off  statement  - is that what you mean?
>     That'd be easiest to get started.

GUC as the default, and SET for per-backend.  I am liking GUC more and
more.


--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: Jan Wieck
Date:
Subject: Re: Configuration of statistical views
Next
From: Jan Wieck
Date:
Subject: Re: Configuration of statistical views