Re: VACUUM and read-mostly tables

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.

Hrm... I'm not sure what the allocation stratedgy is. I guess this is a
case where it would be useful to tell postgresql to allocate space for a
table in large chunks.
--
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?"