On Fri, May 17, 2013 at 1:34 AM, David Rees <[email protected]> wrote: > On Thu, May 16, 2013 at 7:46 AM, Cuong Hoang <[email protected]> wrote: >> For our application, a few seconds of data loss is acceptable. > > If a few seconds of data loss is acceptable, I would seriously look at > the synchronous_commit setting and think about turning that off rather > than risk silent corruption with non-enterprise SSDs.
That is not going to help. Since the drives lie about fsync, upon a power event you must assume the database is corrupt. I think his proposed configuration is the best bet (although I would strongly consider putting SSD on the standby as well). Personally, I think non SSD drives are obsolete for database purposes and will not recommend them for any configuration. Ideally though, OP would be using S3700 and we wouldn't be having this conversation. merlin -- Sent via pgsql-performance mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
