| From: | Michael Monnerie <michael(dot)monnerie(at)it-management(dot)at> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Question on Fragmentations |
| Date: | 2007-02-09 21:51:21 |
| Message-ID: | 200702092251.21883@zmi.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | GABRIEL COLINA | 2007-02-09 23:10:20 | Re: [pgsql-es-ayuda] tabla pg_user Ayuda...... |
| Previous Message | Daniel Medina | 2007-02-09 21:21:10 | Re: tabla pg_user Ayuda...... |