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

-Doug
-- 
The rain man gave me two cures; he said jump right in,
The first was Texas medicine--the second was just railroad gin,
And like a fool I mixed them, and it strangled up my mind,
Now people just get uglier, and I got no sense of time...          --Dylan