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@xxxxxxxxxxx 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?"