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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026