Re: VACUUM and read-mostly tables

On Tue, 2005-04-05 at 00:41, Jim C. Nasby wrote:
> We'll only answer if you do a write-up on your database. :P
>
> Seriously, those are some seriously big numbers. What else is the
> database doing? What hardware is it running on?


We run on a dual 3.2GHz P4 with 2GB RAM, but are still
finalizing the storage hardware.  We've tried various
flavors of RAID, filesystems and volume management (and
are anxious to try out tablespaces in 8).  We've found
fragmentation to be our largest limiting factor.  XFS
helps with that, and seems to provide the highest
sustained throughput on raw tables, but its not the end
of the story since fragmentation is still high.

            --Ian