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