Re: Read consistency when using synchronous_commit=off

Поиск
Список
Период
Сортировка
От Ravi Krishna
Тема Re: Read consistency when using synchronous_commit=off
Дата
Msg-id 1547553278.1840928.1635056376.7E488891@webmail.messagingengine.com
обсуждение исходный текст
Ответ на Re: Read consistency when using synchronous_commit=off  (Fabio Pardi <f.pardi@portavita.eu>)
Ответы Re: Read consistency when using synchronous_commit=off  (pshadangi <pshadangi@gmail.com>)
Список pgsql-general

> I m not sure other clients are able to read from WAL buffer, therefore i m not sure the data is
> available to other clients at that specific point in time.

No.  On the standby the buffer cache has to be populated with the updates before other client sessions can read it.  AFAIK other client sessions do not read WAL buffers.

That is why synchronous_commit=ON option is there.


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

Предыдущее
От: Ian Barwick
Дата:
Сообщение: Re: repmgr and SSH
Следующее
От: "Daniel Verite"
Дата:
Сообщение: RE: Oracke BLOB to Postgres BYTEA using ora2pg