Re: XFS File systems and PostgreSQL

> bruc(at)stone(dot)congenomics(dot)com (Robert E. Bruccoleri) writes:
>
> > 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.
> ^^^^^^^^^^^^^^^^^^^^^^^
>
> Then your performance numbers are largely useless for those of us that
> like our data. ;)
>
> The point at issue is the performance of fsync() on journaling
> filesystems...

Yes, the irony is that a journaling file system is being used to have
fast, reliable restore after crash bootup, but with no fsync, the db is
probably hosed.

--
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