From: Michael Monnerie <michael.monnerie@it-management.at>
To: pgsql-admin@postgresql.org
Subject: Re: Question on Fragmentations
Date: Fri, 9 Feb 2007 22:51:21 +0100
Message-ID: <200702092251.21883@zmi.at> (raw)
In-Reply-To: <45CBE593.4020607@gmail.com>
References: <82e1a9bd0702072149q366a4632hb852ffe41fd2c65c@mail.gmail.com>
<45CBE593.4020607@gmail.com>
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
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: michael.monnerie@it-management.at
Subject: Re: Question on Fragmentations
In-Reply-To: <200702092251.21883@zmi.at>
References: <82e1a9bd0702072149q366a4632hb852ffe41fd2c65c@mail.gmail.com> <45CBE593.4020607@gmail.com> <200702092251.21883@zmi.at>
* 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