Re: PostgreSQL 'Corruption & Fragmentation' detection andresolution/fix - Mailing list pgsql-admin

From pavan95
Subject Re: PostgreSQL 'Corruption & Fragmentation' detection andresolution/fix
Date
Msg-id 1528783795029-0.post@n3.nabble.com
Whole thread Raw
In response to Re: PostgreSQL 'Corruption & Fragmentation' detection and resolution/fix  (Pavan Teja <pavan.postgresdba@gmail.com>)
Responses Re: PostgreSQL 'Corruption & Fragmentation' detection andresolution/fix  (Mark Kirkwood <mark.kirkwood@catalyst.net.nz>)
Re: PostgreSQL 'Corruption & Fragmentation' detection andresolution/fix  (Thomas Kellerer <spam_eater@gmx.net>)
Re: PostgreSQL 'Corruption & Fragmentation' detection andresolution/fix  (Rui DeSousa <rui.desousa@icloud.com>)
List pgsql-admin
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


pgsql-admin by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: pg_stat_activity
Next
From: Mark Kirkwood
Date:
Subject: Re: PostgreSQL 'Corruption & Fragmentation' detection andresolution/fix