> I have been using PostgreSQL and XFS file systems on SGI's for many
> years, and PostgreSQL is fast. Dumping and loading 100GB of table
> files takes less than one day elapsed (provided there is no other
> activity on that database -- large amounts of transactional activity
> will slow things down). I always turn off fsync. Most of my experience has
> been with 6.5.3, although I've been using 7.1 and I don't see much
> of a difference in performance.
>
> I don't know if the Linux version of XFS is substantially different
> than the SGI version, but XFS is a wonderful filesystem to use and
> administer (at least on SGI's).
Yes, but you turn off fsync. It is with fsync on that XFS will be slow.
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026