RE: [PATCH] Support automatic sequence replication - Mailing list pgsql-hackers

From Hayato Kuroda (Fujitsu)
Subject RE: [PATCH] Support automatic sequence replication
Date
Msg-id OS9PR01MB121491AB296883DE7445C0643F577A@OS9PR01MB12149.jpnprd01.prod.outlook.com
Whole thread Raw
In response to Re: [PATCH] Support automatic sequence replication  (Dilip Kumar <dilipbalaut@gmail.com>)
Responses Re: [PATCH] Support automatic sequence replication
List pgsql-hackers
Dear Dilip,

> Thanks for clarifying the use case, and I agree this is a valid use
> case, although I am not completely sure how exactly we are achieving
> that? I mean sequence sync workers need to fetch the list of all
> published sequences to identify whether they are in sync with the
> local sequence state or not?  Or somehow we can avoid that?  If not
> what we would save, updating the local states of the sequences if they
> are already in sync?

IIUC, the sequencesync worker first lists all sequences on the subscriber, then
gets their states on the publisher side. Then the worker updates the state only
when the sequence between instances is different.

Does it make sense for you?

Best regards,
Hayato Kuroda
FUJITSU LIMITED




pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: [PATCH] Support automatic sequence replication
Next
From: Amit Kapila
Date:
Subject: Re: pgstat include expansion