Re: Doc update for pg_stat_statements normalization

Sami Imseih <simseih@amazon.com>

From: "Imseih (AWS), Sami" <simseih@amazon.com>
To: Michael Paquier <michael@paquier.xyz>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2023-03-01T00:43:40Z
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



Commits

  1. doc: Mention de-normalization of deallocated entries in pg_stat_statements