v2.0.0

FEATURES

• Compatible with PostgreSQL 17

BREAKING CHANGES

• PG17 restructured the pg_stat_bgwriter catalog information. This extension has been restructured around those changes:
  • Changed the ccp_stat_bgwriter metric from a materialized view to a standard view
  • Removed columns from ccp_stat_bgwriter that are no longer part of pg_catalog.pg_stat_bgwriter
  • New metrics views created: ccp_stat_checkpointer and ccp_stat_io_bgwriter. These align with where the columns from pg_stat_bgwriter were moved to.
  • For versions of PG older than 17, these new metrics still apply and simply pull that data from the original pg_stat_bgwriter catalog and present them in the new format.
  • All applications that made use of the old ccp_stat_bgwriter metric will need to be updated to use the new metrics.
  • Due to dropping old metrics and recreating new ones, permissions may need to be regranted to any monitoring roles that use these new views.