Re: Script to find out 'Page Corruption' and 'Fragmentation' in PostgreSQL.

Greetings,

* pavan95 (pavan(dot)postgresdba(at)gmail(dot)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