From: Jim C. Nasby <decibel@decibel.org>
To: Ian Westmacott <ianw@intellivid.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: VACUUM and read-mostly tables
Date: Tue, 5 Apr 2005 14:35:08 -0500
Message-ID: <20050405193508.GW93835@decibel.org> (raw)
In-Reply-To: <1112723765.8115.119.camel@spectre.intellivid.com>
References: <000201c53993$b07bb440$76d81e42@hsd1.ma.comcast.net>
<20050405044128.GL93835@decibel.org>
<1112713986.8115.81.camel@spectre.intellivid.com>
<20050405153904.GP93835@decibel.org>
<1112723765.8115.119.camel@spectre.intellivid.com>
On Tue, Apr 05, 2005 at 01:56:05PM -0400, Ian Westmacott wrote:
> > And if UFS is available for linux you should might try it.
>
> Would UFS help the fragmentation issue? We have seen ext3
> allocating blocks in 2-4 pages, while XFS manages 8-16
> pages.
Actually, I spoke too soon in my last reply. UFS has done work to be
more intelligent about where it allocates space from, so it's very
possible that even if it's only allocating a block at a time that it
will be smart enough not to allocate nearby space for other things. I
believe there's also some tuning parameters that affect that behavior.
Of course, other linux filesystems might be tunable in that regard as
well.
--
Jim C. Nasby, Database Consultant decibel@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828
Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"
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: decibel@decibel.org, ianw@intellivid.com
Subject: Re: VACUUM and read-mostly tables
In-Reply-To: <20050405193508.GW93835@decibel.org>
References: <000201c53993$b07bb440$76d81e42@hsd1.ma.comcast.net> <20050405044128.GL93835@decibel.org> <1112713986.8115.81.camel@spectre.intellivid.com> <20050405153904.GP93835@decibel.org> <1112723765.8115.119.camel@spectre.intellivid.com> <20050405193508.GW93835@decibel.org>
* 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