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

-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