Tom Lane wrote:
Yaroslav Mazurak <[EMAIL PROTECTED]> writes:
fsync = false
I'd turn fsync back on - unless you don't mind losing your data after a crash.
This is temporary performance solution - I want get SELECT query result first, but current performance is too low.
Disabling fsync will not help SELECT performance one bit. It would only affect transactions that modify the database.
Fixed. But at this moment primary tasks are *get result* (1st) from SELECT in *reasonable* time (2nd). :)
regards, tom lane
With best regards Yaroslav Mazurak.
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
