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 :-)