Re: Deploying PostgreSQL on CentOS with SSD and Hardware RAID - Mailing list pgsql-general

From Steven Schlansker
Subject Re: Deploying PostgreSQL on CentOS with SSD and Hardware RAID
Date
Msg-id 5B81CC94-0529-45AE-85AB-FF89F2F4AD70@likeness.com
Whole thread Raw
In response to Re: Deploying PostgreSQL on CentOS with SSD and Hardware RAID  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-general
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 :-) 




pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: Deploying PostgreSQL on CentOS with SSD and Hardware RAID
Next
From: Steven Schlansker
Date:
Subject: Re: Deploying PostgreSQL on CentOS with SSD and Hardware RAID