Re: Doc update for pg_stat_statements normalization

From: "Imseih (AWS), Sami" <simseih(at)amazon(dot)com>
To: Michael Paquier <michael(at)paquier(dot)xyz>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Doc update for pg_stat_statements normalization
Date: 2023-03-01 00:43:40
Message-ID: 47069D92-4E61-4F05-8FA6-462F8D81F809@amazon.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> + <para>
> + Queries on which normalization can be applied may be observed with constant
> + values in <structname>pg_stat_statements</structname>, especially when there
> + is a high rate of entry deallocations. To reduce the likelihood of this
> + happening, consider increasing <varname>pg_stat_statements.max</varname>.
> + The <structname>pg_stat_statements_info</structname> view, discussed below
> + in <xref linkend="pgstatstatements-pg-stat-statements-info"/>,
> + provides statistics about entry deallocations.
> + </para>

> Are you OK with this text?

Yes, that makes sense.

Regards,

--
Sami Imseih
Amazon Web Services

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Kirk Wolak 2023-03-01 00:47:15 Re: Proposal: %T Prompt parameter for psql for current time (like Oracle has)
Previous Message Julien Rouhaud 2023-03-01 00:43:10 Re: pg_upgrade and logical replication