Re: PostgreSQL 'Corruption & Fragmentation' detection and resolution/fix

From: pavan95 <pavan(dot)postgresdba(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: PostgreSQL 'Corruption & Fragmentation' detection and resolution/fix
Date: 2018-06-12 06:09:55
Message-ID: 1528783795029-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Mark Kirkwood 2018-06-12 06:54:23 Re: PostgreSQL 'Corruption & Fragmentation' detection and resolution/fix
Previous Message David G. Johnston 2018-06-12 05:58:14 Re: pg_stat_activity