Greetings, * pavan95 (pavan.postgresdba@xxxxxxxxx) 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
Attachment:
signature.asc
Description: PGP signature
