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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: pgsql-admin@xxxxxxxxxxxxxxxxxxxx
Subject: Re: PostgreSQL 'Corruption & Fragmentation' detection and resolution/fix
From: Thomas Kellerer <spam_eater@xxxxxxx>
Date: Tue, 12 Jun 2018 09:42:06 +0200
In-reply-to: <1528783795029-0.post@n3.nabble.com>
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>
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

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

References:
- Re: PostgreSQL 'Corruption & Fragmentation' detection and resolution/fix
  - From: pavan95
- Re: PostgreSQL 'Corruption & Fragmentation' detection and resolution/fix
  - From: Rui DeSousa
- Re: PostgreSQL 'Corruption & Fragmentation' detection and resolution/fix
  - From: Pavan Teja
- Re: PostgreSQL 'Corruption & Fragmentation' detection and resolution/fix
  - From: Rui DeSousa
- Re: PostgreSQL 'Corruption & Fragmentation' detection and resolution/fix
  - From: Pavan Teja
- Re: PostgreSQL 'Corruption & Fragmentation' detection and resolution/fix
  - From: Rui DeSousa
- Re: PostgreSQL 'Corruption & Fragmentation' detection and resolution/fix
  - From: Pavan Teja
- Re: PostgreSQL 'Corruption & Fragmentation' detection and resolution/fix
  - From: pavan95

Prev by Date: Re: PostgreSQL 'Corruption & Fragmentation' detection and resolution/fix
Next by Date: Re: pg_stat_activity
Previous by thread: Re: PostgreSQL 'Corruption & Fragmentation' detection and resolution/fix
Next by thread: Re: PostgreSQL 'Corruption & Fragmentation' detection and resolution/fix
Index(es):
- Date
- Thread

[Index of Archives] [KVM ARM] [KVM ia64] [KVM ppc] [Virtualization Tools] [Spice Development] [Libvirt] [Libvirt Users] [Linux USB Devel] [Linux Audio Users] [Yosemite Questions] [Linux Kernel] [Linux SCSI] [XFree86]