Re: Question on Fragmentations - Mailing list pgsql-admin

From Michael Monnerie
Subject Re: Question on Fragmentations
Date
Msg-id 200702092251.21883@zmi.at
Whole thread Raw
In response to Re: Question on Fragmentations  (Peter Koczan <pjkoczan@gmail.com>)
Responses Re: Question on Fragmentations  (Peter Koczan <pjkoczan@gmail.com>)
List pgsql-admin
On Freitag, 9. Februar 2007 04:08 Peter Koczan wrote:
> Case in point, I use xfs as the filesystem running under postgres,
> and after a few days the "major" database clusters showed ~90%
> fragmentation on their respective partitions (which is about a 10 to
> 1 ratio of file fragments to files). After running a defragmenter

Does xfs have such stats, and defragmenter included? It could be a good
idea for me to use that, then. Currently I use reiserfs.

mfg zmi
--
// Michael Monnerie, Ing.BSc    -----      http://it-management.at
// Tel: 0676/846 914 666                      .network.your.ideas.
// PGP Key:        "curl -s http://zmi.at/zmi4.asc | gpg --import"
// Fingerprint: EA39 8918 EDFF 0A68 ACFB  11B7 BA2D 060F 1C6F E6B0
// Keyserver: www.keyserver.net                   Key-ID: 1C6FE6B0

Attachment

pgsql-admin by date:

Previous
From: Daniel Medina
Date:
Subject: Re: tabla pg_user Ayuda......
Next
From: GABRIEL COLINA
Date:
Subject: Re: [pgsql-es-ayuda] tabla pg_user Ayuda......