Re: How to check for in-progress transactions

Поиск
Список
Период
Сортировка
От Tejasvi Kashi
Тема Re: How to check for in-progress transactions
Дата
Msg-id CAJWWkaqsrBjz9Nc42ponaYQCBK-HsO8s2=UNjSdwBsp4fYk2mQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: How to check for in-progress transactions  (Melanie Plageman <melanieplageman@gmail.com>)
Список pgsql-hackers
Дерево обсуждения
On Thu, Mar 16, 2023 at 17:01, Melanie Plageman <melanieplageman@gmail.com> wrote:
On Thu, Mar 16, 2023 at 4:43 PM Tejasvi Kashi <mail@tejasvi.dev> wrote:
> Thanks a lot for your reply. It looks like this is exactly what I need. For my use case, I'm trying to get read-only transactions to wait for the replication of prior writes.

can't you use remote_apply?

https://www.postgresql.org/docs/15/runtime-config-wal.html

That will ensure that the writes are acknowledged only after remote application. But, in my case, I’m trying to get read transactions to wait if they have seen a write that is yet to be replicated. 


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

Предыдущее
От: Melanie Plageman
Дата:
Сообщение: Re: How to check for in-progress transactions
Следующее
От: Justin Pryzby
Дата:
Сообщение: Re: doc: mentioned CREATE+ATTACH PARTITION as an alternative to CREATE TABLE..PARTITION OF