Re: logical decoding and replication of sequences, take 2 - Mailing list pgsql-hackers

From Andres Freund
Subject Re: logical decoding and replication of sequences, take 2
Date
Msg-id 20230111205810.6dikfcbaqep5jcdm@awork3.anarazel.de
Whole thread Raw
In response to Re: logical decoding and replication of sequences, take 2  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: logical decoding and replication of sequences, take 2
List pgsql-hackers
Hi,

On 2023-01-11 15:41:45 -0500, Robert Haas wrote:
> I wonder, then, what happens if somebody wants to do parallel apply.  That
> would seem to require some relaxation of this rule, but then doesn't that
> break what this patch wants to do?

I don't think it'd pose a direct problem - presumably you'd only parallelize
applying changes, not committing the transactions containing them. You'd get a
lot of inconsistencies otherwise.

If you're thinking of decoding changes in parallel (rather than streaming out
large changes before commit when possible), you'd only be able to do that in
cases when transaction haven't performed catalog changes, I think. In which
case there'd also be no issue wrt transactional sequence changes.

Greetings,

Andres Freund



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: low wal_retrieve_retry_interval causes missed signals on Windows
Next
From: Tom Lane
Date:
Subject: Re: ATTACH PARTITION seems to ignore column generation status