Re: track_planning causing performance regression

Поиск
Список
Период
Сортировка
От Julien Rouhaud
Тема Re: track_planning causing performance regression
Дата
Msg-id CAOBaU_ZxTGMapnWTCGaEiAHochUjzEB5XQN3hqbuf0xspDwSbg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: track_planning causing performance regression  (Fujii Masao <masao.fujii@oss.nttdata.com>)
Ответы Re: track_planning causing performance regression
Список pgsql-hackers
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!



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

Предыдущее
От: Andy Fan
Дата:
Сообщение: Re: Keep notnullattrs in RelOptInfo (Was part of UniqueKey patch series)
Следующее
От: Julien Rouhaud
Дата:
Сообщение: Re: Hook for extensible parsing.