Re: wishlist: dynamic log volume control

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.
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> If the Catholic church can survive the printing press, science fiction
> will certainly weather the advent of bookwarez.
>    http://craphound.com/ebooksneitherenorbooks.txt - Cory Doctorow