Re: suggestion: log_statement = sample

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: suggestion: log_statement = sample
Дата
Msg-id 11547.1248184176@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: suggestion: log_statement = sample  (Janning Vygen <vygen@kicktipp.de>)
Ответы Re: suggestion: log_statement = sample
Список 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 по дате отправления:

Предыдущее
От: Phoenix Kiula
Дата:
Сообщение: Re: First query very slow. Solutions: memory, or settings, or SQL?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: array_agg crash?