Re: track_planning causing performance regression

Поиск
Список
Период
Сортировка
От Fujii Masao
Тема Re: track_planning causing performance regression
Дата
Msg-id cef9be18-161c-98b9-ed0d-a23dc973df49@oss.nttdata.com
обсуждение исходный текст
Ответ на Re: track_planning causing performance regression  (Julien Rouhaud <rjuju123@gmail.com>)
Ответы Re: track_planning causing performance regression  (Julien Rouhaud <rjuju123@gmail.com>)
Список pgsql-hackers

On 2021/07/07 18:09, Julien Rouhaud wrote:
> On Thu, Jul 1, 2021 at 4:28 PM Fujii Masao <masao.fujii@oss.nttdata.com> wrote:
>>
>> I'm fine with this. So what about the following diff? I added <structname> tag.
>>
>>          <varname>pg_stat_statements.track_planning</varname> controls whether
>>          planning operations and duration are tracked by the module.
>>          Enabling this parameter may incur a noticeable performance penalty,
>> -      especially when a fewer kinds of queries are executed on many
>> -      concurrent connections.
>> +      especially when statements with identical query structure are executed
>> +      by many concurrent connections which compete to update a small number of
>> +      <structname>pg_stat_statements</structname> entries.
>>          The default value is <literal>off</literal>.
>>          Only superusers can change this setting.
> 
> It seems perfect, thanks!

Pushed. Thanks!

Regards,

-- 
Fujii Masao
Advanced Computing Technology Center
Research and Development Headquarters
NTT DATA CORPORATION



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

Предыдущее
От: Tatsuo Ishii
Дата:
Сообщение: Re: [HACKERS] WIP aPatch: Pgbench Serialization and deadlock errors
Следующее
От: Julien Rouhaud
Дата:
Сообщение: Re: track_planning causing performance regression