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
Список 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 по дате отправления: