Re: [Proposal] global sequence implemented by snowflake ID - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: [Proposal] global sequence implemented by snowflake ID
Date
Msg-id ZV8tM_5n_53BOzVz@paquier.xyz
Whole thread Raw
In response to [Proposal] global sequence implemented by snowflake ID  ("Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>)
Responses Re: [Proposal] global sequence implemented by snowflake ID
List pgsql-hackers
On Thu, Nov 23, 2023 at 10:18:59AM +0000, Hayato Kuroda (Fujitsu) wrote:
> * Implement as a variant of sequence access method. I found that sequence AM was
>   proposed many years ago [5], but it has not been active now. It might be a
>   fundamental way but needs a huge works.

Well, that's what I can call a timely proposal.  I've been working
this week on a design for sequence AMs, while considering the cases
that the original thread wanted to handle (spoiler: there are a lot of
pieces in the original patch that are not necessary, other parts are
incorrect like dump/restore), what you are trying to do here, and more
complex scenarios in terms of globally-distributed sequences.  My plan
was to send that next week or the week after, in time for January's
CF.
--
Michael

Attachment

pgsql-hackers by date:

Previous
From: John Naylor
Date:
Subject: Re: Change GUC hashtable to use simplehash?
Next
From: Amit Kapila
Date:
Subject: Re: Synchronizing slots from primary to standby