Re: XFS File systems and PostgreSQL

> 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