Side effect of synchronous_commit = off

Поиск
Список
Период
Сортировка
От Yan Cheng CHEOK
Тема Side effect of synchronous_commit = off
Дата
Msg-id 856369.90827.qm@web65703.mail.ac4.yahoo.com
обсуждение исходный текст
Ответы Re: Side effect of synchronous_commit = off  (Guillaume Lelarge <guillaume@lelarge.info>)
Re: Side effect of synchronous_commit = off  (Arthur Turrini <atgnbk@gmail.com>)
Список pgsql-general
I was wondering whether setting synchronous_commit = off will have the following side effect.

(1) Process A issues UPDATE command on row x, from false to true.
(2) After that, Process B READ from row x.

Is it possible that when Process B start to read row x, the "true" value is not being "flushed" to the table. Hence,
processB will read the row x as false? 

If this situation will happen, is it possible that Process B may issues a command, use to "flush all" pending data to
bewritten to disk? 

Thanks and Regards
Yan Cheng CHEOK





В списке pgsql-general по дате отправления:

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: find a string contained in an attribute
Следующее
От: Adrian von Bidder
Дата:
Сообщение: Re: Revoking CREATE TABLE