Hi All!

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]

Reply via email to