> [EMAIL PROTECTED] (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
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
