> As of now, we are adding handling inside pg_stat_reset for shared > tables but I think we can add a new function with the name of > pg_stat_reset_shared_tables to reset stats for all the shared tables. > New function will give more clarity to the users also. We already have > a pg_stat_reset_shared(text) function for "archiver", "bgwriter", or > "wal". > > Thoughts?
In my opinion, it is better to extend the functionality of "pg_stat_reset" call because a new function just to reset shared table data may not be needed. Where we already have a reset shared function "pg_stat_reset_shared" in place. All of applicable comments are implemented in the patch below: Thanks & Regards SadhuPrasad EnterpriseDB: http://www.enterprisedb.com
v2-0001-DB-1318-pg_stat_reset-and-pg_stat_reset_single_ta.patch
Description: Binary data