Re: XFS File systems and PostgreSQL

> bruc@stone.congenomics.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@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