SET LOCAL synchronous_commit TO OFF

Поиск
Список
Период
Сортировка
От Robert DiFalco
Тема SET LOCAL synchronous_commit TO OFF
Дата
Msg-id CAAXGW-xtkBBUeipUBL2mAKLdOiJ_uD+YS3u4aucAQw1AbiKm9w@mail.gmail.com
обсуждение исходный текст
Ответы Re: SET LOCAL synchronous_commit TO OFF  (Thom Brown <thom@linux.com>)
Список pgsql-general
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 по дате отправления:

Предыдущее
От: asmariyaz23
Дата:
Сообщение: Installing Postgres manually GCC error and libmpfr.so.4 not found
Следующее
От: Arup Rakshit
Дата:
Сообщение: Random order by but first 3