Greetings,
* pavan95 (pavan.postgresdba@gmail.com) wrote:
> I am looking for a script and its explanation of how to calculate *page
> corruption* and* fragmentation* of a relation in PostgreSQL.
When it comes to fragmentation, you might look at pg_freespacemap. If
you'd like a tool which checks all of the page-level checksums (assuming
you have them enabled..), then you might look at pgBackRest which
verifies the page-level checksums during backups. You could do a
partial check with pg_dump but that will generally only look at heap
pages and not index pages.
There can be other corruption in a page, of course, and between the heap
and indexes- you might consider looking at amcheck to see about checking
indexes.
Thanks!
Stephen