Postgres Pro
Downloads
Home   >   mailing lists

SET LOCAL synchronous_commit TO OFF - Mailing list pgsql-general

From Robert DiFalco
Subject SET LOCAL synchronous_commit TO OFF
Date
Msg-id CAAXGW-xtkBBUeipUBL2mAKLdOiJ_uD+YS3u4aucAQw1AbiKm9w@mail.gmail.com
Whole thread Raw
Responses Re: SET LOCAL synchronous_commit TO OFF
List pgsql-general
Tree view
I want to make sure I understand the repercussions of this before making it a global setting. 

As far as I can tell this will put data/referential integrity at risk. It only means that there is a period of time (maybe 600 msecs) between when a commit occurs and when that data is safe in the case of a server crash. 

Is there anything else I'm missing?

pgsql-general by date:

Previous
From: asmariyaz23
Date:
Subject: Installing Postgres manually GCC error and libmpfr.so.4 not found
Next
From: Arup Rakshit
Date:
Subject: Random order by but first 3