Postgres Pro
Downloads
Home   >   mailing lists

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

From Thomas Kellerer
Subject Re: PostgreSQL 'Corruption & Fragmentation' detection andresolution/fix
Date
Msg-id 38c4642f-180d-ed65-de2a-ab1a3595156d@gmx.net
Whole thread Raw
In response to Re: PostgreSQL 'Corruption & Fragmentation' detection andresolution/fix  (pavan95 <pavan.postgresdba@gmail.com>)
List pgsql-admin
Tree view 
pavan95 schrieb am 12.06.2018 um 08:09:
> Can we get any information regarding fragmentation/corruption in the
> database level from the system table 

Fragmentation and corruption are two *very* different things. 

And with modern harddisks (SSD and similar technologies) fragmentation is not an issue any more

pgsql-admin by date:

Previous
From: Mark Kirkwood
Date:
Subject: Re: PostgreSQL 'Corruption & Fragmentation' detection andresolution/fix
Next
From: pavan95
Date:
Subject: Re: pg_stat_activity