Radu-Adrian Popescu <[EMAIL PROTECTED]> writes: > I belive you should set > fsync=false > in case you mainly select and do inserts rather rare.
No, that's a really horrid reason to turn off fsync. A read-only transaction never syncs and thus has no fsync penalty. If update performance isn't a serious problem for you, you may as well keep fsync on and not have to worry about data loss in the case of a system crash. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])