Re: track_planning causing performance regression

From: Fujii Masao <masao(dot)fujii(at)oss(dot)nttdata(dot)com>
To: Justin Pryzby <pryzby(at)telsasoft(dot)com>
Cc: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, Peter Geoghegan <pg(at)bowt(dot)ie>, Julien Rouhaud <rjuju123(at)gmail(dot)com>, "Tharakan, Robins" <tharar(at)amazon(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: track_planning causing performance regression
Date: 2021-04-21 14:38:52
Message-ID: b86e33bf-d549-db6b-f50b-3cb077807a71@oss.nttdata.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 2021/04/19 23:55, Justin Pryzby wrote:
> What does "kind" mean ? I think it means a "normalized" query or a "query
> structure".
>
> "a fewer kinds" is wrong, so I think the docs should say "a small number of
> queries" or maybe:

Okay, I agree to update the description.

>>>> Enabling this parameter may incur a noticeable performance penalty,
>>>> especially similar queries are run by many concurrent connections and
>>>> compete to update the same pg_stat_statements entry

"a small number of" is better than "similar" at the above because
"similar" sounds a bit unclear in this case?

It's better to use "entries" rather than "entry" at the above?

Regards,

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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2021-04-21 14:39:54 Re: PATCH: Add GSSAPI ccache_name option to libpq
Previous Message Andrew Dunstan 2021-04-21 14:32:40 Re: Free port choosing freezes when PostgresNode::use_tcp is used on BSD systems