> 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