Re: wishlist: dynamic log volume control

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