X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C4CEA52A9F for ; Tue, 5 Apr 2005 20:35:08 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 56686-04 for ; Tue, 5 Apr 2005 19:35:07 +0000 (GMT) Received: from flake.decibel.org (flake.decibel.org [67.100.216.10]) by svr1.postgresql.org (Postfix) with ESMTP id 3E28152A7C for ; Tue, 5 Apr 2005 20:35:07 +0100 (BST) Received: by flake.decibel.org (Postfix, from userid 1001) id 3C1FE15449; Tue, 5 Apr 2005 14:35:08 -0500 (CDT) Date: Tue, 5 Apr 2005 14:35:08 -0500 From: "Jim C. Nasby" To: Ian Westmacott Cc: pgsql-admin@postgresql.org Subject: Re: VACUUM and read-mostly tables Message-ID: <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> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1112723765.8115.119.camel@spectre.intellivid.com> X-Operating-System: FreeBSD 4.11-RELEASE i386 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.8i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.022 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200504/68 X-Sequence-Number: 17081 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?"