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

help / color / mirror / Atom feed
From: Thomas Kellerer <spam_eater@gmx.net>
To: pgsql-admin@lists.postgresql.org
Subject: Re: PostgreSQL 'Corruption & Fragmentation' detection and resolution/fix
Date: Tue, 12 Jun 2018 09:42:06 +0200
Message-ID: <38c4642f-180d-ed65-de2a-ab1a3595156d@gmx.net> (raw)
In-Reply-To: <1528783795029-0.post@n3.nabble.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>
	<1528783795029-0.post@n3.nabble.com>

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






view thread (19+ messages)  latest in thread

Message-ID: <38c4642f-180d-ed65-de2a-ab1a3595156d@gmx.net>
Permalink:  ../38c4642f-180d-ed65-de2a-ab1a3595156d@gmx.net/
Also on:    postgresql.org/message-id/38c4642f-180d-ed65-de2a-ab1a3595156d@gmx.net

 · 

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: spam_eater@gmx.net, pgsql-admin@lists.postgresql.org
  Subject: Re: PostgreSQL 'Corruption & Fragmentation' detection and resolution/fix
  In-Reply-To: <38c4642f-180d-ed65-de2a-ab1a3595156d@gmx.net>

* 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