Re: Deploying PostgreSQL on CentOS with SSD and Hardware RAID

On May 10, 2013, at 11:38 AM, Merlin Moncure <mmoncure@gmail.com> wrote:
>>
>> PostgreSQL configuration changes:
>> synchronous_commit = off
>>
>
> that's good info, but it should be noted that synchronous_commit
> trades a risk of some data loss (but not nearly as much risk as
> volatile storage) for a big increase in commit performance.

Yes, that is a choice we consciously made.  If our DB server crashes losing the last few ms worth of transactions is an
acceptableloss to us.  But that may not be OK for everyone :-)