Re: Maximum Performance Follow-up Question - Mailing list pgsql-admin

From Tom Lane
Subject Re: Maximum Performance Follow-up Question
Date
Msg-id 25432.1011972211@sss.pgh.pa.us
Whole thread Raw
In response to Re: Maximum Performance Follow-up Question  (Radu-Adrian Popescu <radu.popescu@aldratech.com>)
Responses Re: Maximum Performance Follow-up Question  ("Peter T. Brown" <peter@memeticsystems.com>)
List pgsql-admin
Radu-Adrian Popescu <radu.popescu@aldratech.com> 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

pgsql-admin by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Vacuum and Vacuum analyse
Next
From: "Zhang, Anna"
Date:
Subject: Re: Increasing Shared Memory - on MacOS X