wishlist: dynamic log volume control - Mailing list pgsql-general

From Ed L.
Subject wishlist: dynamic log volume control
Date
Msg-id 200402181554.39460.pgsql@bluepolka.net
Whole thread Raw
Responses Re: wishlist: dynamic log volume control  (Martijn van Oosterhout <kleptog@svana.org>)
Re: wishlist: dynamic log volume control  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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...


pgsql-general by date:

Previous
From: Jeff Davis
Date:
Subject: Re: Differences between postgres and mysql
Next
From: Andrew Sullivan
Date:
Subject: Re: Replication in postgresql