Subject: Re: PostgreSQL 'Corruption & Fragmentation' detection and
 resolution/fix
To: pgsql-admin@lists.postgresql.org
Newsgroups: gmane.comp.db.postgresql.admin
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>
 <1528783795029-0.post@n3.nabble.com>
From: Thomas Kellerer <spam_eater@gmx.net>
Message-ID: <38c4642f-180d-ed65-de2a-ab1a3595156d@gmx.net>
Date: Tue, 12 Jun 2018 09:42:06 +0200
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.23)
 Gecko/20090812 Thunderbird/2.0.0.23 Mnenhy/0.7.6.666
MIME-Version: 1.0
In-Reply-To: <1528783795029-0.post@n3.nabble.com>
Content-Type: text/plain; charset=utf-8
Content-Language: de-DE
Content-Transfer-Encoding: 7bit
Precedence: bulk

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