Postgres Pro
Downloads
Home   >   mailing lists

Script to find out 'Page Corruption' and 'Fragmentation' inPostgreSQL. - Mailing list pgsql-admin

From pavan95
Subject Script to find out 'Page Corruption' and 'Fragmentation' inPostgreSQL.
Date
Msg-id 1519120261856-0.post@n3.nabble.com
Whole thread Raw
Responses Re: Script to find out 'Page Corruption' and 'Fragmentation' inPostgreSQL.  (Stephen Frost <sfrost@snowman.net>)
List pgsql-admin
Tree view 
Hi all,

I am looking for a script and its explanation of how to calculate *page
corruption* and* fragmentation* of a relation in PostgreSQL.

Looked many blogs, but unable to find the one.  Unable to understand the
concept of  database checksums part in Page Corruption and Fragmentation.

Looking forward for your valuable suggestions. Help me to find these across
the relations of Postgresql database. Thanks in Advance.

regards,
Pavan



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html

pgsql-admin by date:

Previous
From: Iñigo Salvat
Date:
Subject: Re: Migrate streaming replication 9.4 to 9.6
Next
From: Stephen Frost
Date:
Subject: Re: Disable /Suppress hostname checks while secured LDAP