Martijn van Oosterhout wrote:
-- Start of PGP signed section.
> On Wed, Feb 18, 2004 at 03:54:39PM -0700, Ed L. wrote:
> >
> > We extract great value from logging every SQL statement, its duration, etc.,
> > in service to debugging, troubleshooting, monitoring, etc. But we have a
> > number of clusters that seem to always be bumping into disk I/O
> > bottlenecks. With a system running at 100 QPS, we're inclined to quiet the
> > logging and only turn it up as needed (which will, by definition, be while
> > it was quieted). But many of these production clusters are not easily
> > restarted; the customer has to be notified, etc. "It'd be nice" if we
> > could adjust the volume of logging dynamically (i.e., turn-off of statement
> > logging, etc) without have to restart the server...
>
> In any particular session you can do SET log_statement = off or some such.
> That way you can make logging more fine grained.
You can also change the postgresql.conf file and SIGHUP the postmaster
for it to take affect. It doesn't restart the server.
--
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
