From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
---|---|
To: | "Ed L(dot)" <pgsql(at)bluepolka(dot)net> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: wishlist: dynamic log volume control |
Date: | 2004-02-18 23:15:34 |
Message-ID: | 20040218231534.GA25848@svana.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)svana(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Huxton | 2004-02-18 23:26:54 | Re: [Re] Need help with postgresql/apache/php optimisation |
Previous Message | Froggy / Froggy Corp. | 2004-02-18 23:12:57 | Re: [Re] Need help with postgresql/apache/php optimisation |