pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed

Script to find out 'Page Corruption' and 'Fragmentation' in PostgreSQL.
2+ messages / 2 participants
[nested] [flat]

* Script to find out 'Page Corruption' and 'Fragmentation' in PostgreSQL.
@ 2018-02-20 09:51  pavan95 <pavan.postgresdba@gmail.com>
  0 siblings, 1 reply; 2+ messages in thread

From: pavan95 @ 2018-02-20 09:51 UTC (permalink / raw)
  To: pgsql-admin

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




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Script to find out 'Page Corruption' and 'Fragmentation' in PostgreSQL.
@ 2018-02-20 14:54  Stephen Frost <sfrost@snowman.net>
  parent: pavan95 <pavan.postgresdba@gmail.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Stephen Frost @ 2018-02-20 14:54 UTC (permalink / raw)
  To: pavan95 <pavan.postgresdba@gmail.com>; +Cc: pgsql-admin

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

Attachments:

  signature.asc (application/pgp-signature, 818B) download

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2018-02-20 14:54 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2018-02-20 09:51 Script to find out 'Page Corruption' and 'Fragmentation' in PostgreSQL. pavan95 <pavan.postgresdba@gmail.com>
2018-02-20 14:54 ` Stephen Frost <sfrost@snowman.net>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox