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 [EMAIL PROTECTED]
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?"
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
