Re: stats_command_string default?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: stats_command_string default?
Дата
Msg-id 1148.1045449006@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: stats_command_string default?  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
Список pgsql-hackers
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au> writes:
>> My conclusion is that stats_command_string overhead is non-negligible
>> for simple commands.  So I stand by my previous opinion that it should
>> not be turned on without the DBA taking explicit action to turn it on.

> How about with the stats_collector on?  ie. Recording block and row level
> stats?

Didn't measure that, but I believe the block/row stats are dumped to the
collector once per transaction, so the overhead ought to be roughly
comparable to this test.
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Christopher Kings-Lynne"
Дата:
Сообщение: Hard problem with concurrency
Следующее
От: mlw
Дата:
Сообщение: Re: location of the configuration files