Search Postgresql Archives
synchronous replication + fsync=off?
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
- To: <pgsql-general@xxxxxxxxxxxxxx>
- Subject: synchronous replication + fsync=off?
- From: "Schubert, Joerg" <jschubert@xxxxxxxxxx>
- Date: Thu, 17 Nov 2011 13:52:07 +0100
- Thread-index: AcylJ7adqaLK0CyeQCisecSmrGNq3g==
- Thread-topic: synchronous replication + fsync=off?
Hello,
I have two servers with battery backed power supply (USV). So it is unlikely, that both will crash at the same time.
Will synchronous replication work with fsync=off?
That means we will commit to system cache, but not to disk. Data will not survive a system crash but the second system should still be consistent.
Or: will it work with
master: fsync=off
and
slave(s): fsync=on?
In this case master is free for read-queries and slave has time to do all the heavy writing. Data on master will not survive a crash but can be restored from slave.
Thanks,
Joerg
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]
[Postgresql Jobs]
[Postgresql Admin]
[Postgresql Performance]
[Linux Clusters]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Books]
[PHP Databases]
[Postgresql & PHP]
[Yosemite]