Read consistency when using synchronous_commit=off

Поиск
Список
Период
Сортировка
От pshadangi
Тема Read consistency when using synchronous_commit=off
Дата
Msg-id CAA+OQsSRuQX8vaDV0=v5x9U0Vcj_1G71aTCQ7wx+YBE==uHvEQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: Read consistency when using synchronous_commit=off  (Fabio Pardi <f.pardi@portavita.eu>)
Список pgsql-general
To improve commit performance we are planning to use "synchronous_commit=off", with this if multiple clients are reading the same data/row will they always get the latest updated data/row ? (clients are using committed read and we are not using clustered environment, we have just one instance of postgres serving local clients running on the same machine).
For example if client1 updates a row then the updated value is available to client2 immediately after the commit or there is a delay as commit is now asynchronous ?

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

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: Oracke BLOB to Postgres BYTEA using ora2pg
Следующее
От: Fabio Pardi
Дата:
Сообщение: Re: Read consistency when using synchronous_commit=off