What does this patch give on aglobal scale? Does it save much memory or increase performance? How many times?

This patch makes the code semantically more correct and we don't lose anything. It is obviously not about performance or memory optimisation.

This will only reduce the size of the
$PGDATA/pg_stat/pg_stat_statements.txt file. Even with
100k entries, the most I have seen pg_stat_statements.max
set to, that will be less than 1 MB of disk saving. The default
config of 5k entries will be much less.

Perfectly agree. I would just add that statistics are dropped into the pg_stat_statements.txt file at server stop which is not a very frequent event.

Respectfully,

Mikhail Litsarev,
Postgres Professional: https://postgrespro.com


Reply via email to