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

help / color / mirror / Atom feed
From: pavan95 <pavan.postgresdba@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: PostgreSQL 'Corruption & Fragmentation' detection and resolution/fix
Date: Mon, 11 Jun 2018 23:09:55 -0700 (MST)
Message-ID: <1528783795029-0.post@n3.nabble.com> (raw)
In-Reply-To: <CACh9nsYOacwJ6D_sVenarjpVNNXgDdhSP-bFpdXVmoms5fkLOw@mail.gmail.com>
References: <1528723690634-0.post@n3.nabble.com>
	<477ADE32-3CCE-4A9A-A286-ADDAB0B4F74B@icloud.com>
	<CACh9nsZ9EmeEZv3u1s+iDQ6stv5+ARi=pWvz0hXaOMW4izFrPQ@mail.gmail.com>
	<A7B2C6A7-22A0-40DC-8C2C-963C8AFDEA87@icloud.com>
	<CACh9nsYgS6-5YO8bp7uex9WUTu2XwFNHGbP=aR5DkQoO4NPwHA@mail.gmail.com>
	<B7E2FA3A-5D81-4EBD-977E-1958520298AE@icloud.com>
	<CACh9nsYOacwJ6D_sVenarjpVNNXgDdhSP-bFpdXVmoms5fkLOw@mail.gmail.com>

Hi,

Can we get any information regarding fragmentation/corruption in the
database level from the system table 

"Information_schema.columns" ?  

Actually my strong belief is  other databases like SQL server, Oracle &
Mysql are providing some system views to detect corruption and fragmentation
from the database. So thinking the same with the postgres.

As I was asked to prepare a script well in advance to predict the
forthcoming disasters

Regards,
Pavan



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




view thread (19+ messages)  latest in thread

Message-ID: <1528783795029-0.post@n3.nabble.com>
Permalink:  ../1528783795029-0.post@n3.nabble.com/
Also on:    postgresql.org/message-id/1528783795029-0.post@n3.nabble.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: pavan.postgresdba@gmail.com
  Subject: Re: PostgreSQL 'Corruption & Fragmentation' detection and resolution/fix
  In-Reply-To: <1528783795029-0.post@n3.nabble.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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