pg_gather icon indicating copy to clipboard operation
pg_gather copied to clipboard

Published 20 hours ago • verified publisher icon jobinau

New feature request: MultiXactId reporting

Open psvampa opened this issue 1 year ago • 2 comments

Hello Jobin, Currently, pg_gather reports the database/relation age. Over the last time, I faced a few MultiXactId scenarios. I would like pg_gather to report this if possible. Best Regards,

psvampa avatar Oct 10 '23 16:10 psvampa

Thank you, @psvampa, for raising this new feature request. This is something which I have been considering for quite long. It wasn't included because there was little clarity on what could add value. Let me think further about this. Meanwhile, I welcome ideas about how to have a meaningful/effective analysis.

jobinau avatar Oct 10 '23 17:10 jobinau

https://github.com/jobinau/pg_gather/pull/42 adds DB-level multixactid verification. If it becomes helpful, a threshold-based warning could be added, similar to the report's other warnings.

psvampa avatar Nov 27 '23 22:11 psvampa