"Peter T. Brown" <[EMAIL PROTECTED]> writes:
> Is there any BIG risk in turning fsync off?

No, I wouldn't say so if you consider your data noncritical.  fsync is
for stuff like orders and bank accounts, where losing even one
committed transaction is not acceptable.

> And isn't there some way to use fsync but just use it less frequently,

That's pretty much what you get with fsync off: the Unix system will
still flush data to disk every 30 sec or so (see syncer daemon's man
page).

                        regards, tom lane

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

Reply via email to