Re: suggestion: log_statement = sample - Mailing list pgsql-general

From Tom Lane
Subject Re: suggestion: log_statement = sample
Date
Msg-id 11547.1248184176@sss.pgh.pa.us
Whole thread Raw
In response to Re: suggestion: log_statement = sample  (Janning Vygen <vygen@kicktipp.de>)
Responses Re: suggestion: log_statement = sample
List pgsql-general
Janning Vygen <vygen@kicktipp.de> writes:
> On Monday 20 July 2009 19:24:13 Bill Moran wrote:
>> Have you benchmarked the load it creates under your workload?

> Yes, it takes up to 15% of our workload in an average use case. But we have
> peak times where we can not afford 15% lost for logging!

Well, you could turn it off during the peak times.  Or buy better
hardware --- if you have less than 15% headroom then it's past time
to be doing that anyway.

You really haven't given any convincing case for this behavior...

            regards, tom lane

pgsql-general by date:

Previous
From: Phoenix Kiula
Date:
Subject: Re: First query very slow. Solutions: memory, or settings, or SQL?
Next
From: Tom Lane
Date:
Subject: Re: array_agg crash?