Horton

Add support for pg_stat_reset_slru without argument

Michael Paquier <michael@paquier.xyz>

View on postgr.es
Commit: e5cca6288a4098cf731599b5977b0f6714ba0ac6
Author: Michael Paquier <michael@paquier.xyz>
Date: 2023-11-14T00:50:52Z
Releases: 17.0 
Add support for pg_stat_reset_slru without argument

pg_stat_reset_slru currently requires an input argument, either:
- NULL to reset the SLRU counters of everything.
- A specific value to reset a single SLRU cache.

This commit adds support for a new pattern: pg_stat_reset_slru without
any argument works the same way as pg_stat_reset_slru(NULL), relying on
a DEFAULT in the function definition to handle this case.  This makes
the function more consistent with 23c8c0c8f472.

Bump catalog version.

Author: Bharath Rupireddy
Reviewed-by: Atsushi Torikoshi
Discussion: https://postgr.es/m/CALj2ACW1VizYg01EeH_cA-7qA+4NzWVAoZ5Lw9_XYO1RRHAZbA@mail.gmail.com

Files

PathChange+/−
doc/src/sgml/monitoring.sgml modified +4 −3
src/backend/catalog/system_functions.sql modified +7 −0
src/include/catalog/catversion.h modified +1 −1
src/include/catalog/pg_proc.dat modified +2 −1
src/test/regress/expected/stats.out modified +1 −1
src/test/regress/sql/stats.sql modified +1 −1

Documentation touched

Discussion