Re: Sequence Access Methods, round two - Mailing list pgsql-hackers

From Andrei Lepikhov
Subject Re: Sequence Access Methods, round two
Date
Msg-id e10e3067-9e95-40f0-be84-de59787bf742@gmail.com
Whole thread
In response to Re: Sequence Access Methods, round two  (Chao Li <li.evan.chao@gmail.com>)
Responses Re: Sequence Access Methods, round two
List pgsql-hackers
On 18/05/2026 00:43, Michael Paquier wrote:
> On Sun, May 17, 2026 at 08:03:15AM +0200, Andrei Lepikhov wrote:
>> Right now, awaiting this feature, I use a nextval hook. But it is just to
>> minimise the number of core lines that need to be changed. Neither hook nor
>> callback is a good idea here - sequence source might be only one for a specific
>> table; \d should show an unequivocal definition of a table.
>> Also, the AM machinery makes the dump/restore use cases clear. Logical
>> replication plugins also benefit from it: pgactive, pglogical, and spock all
>> include Auto-DDL solutions that simplify the management of sequence generation
>> methods across instances.
> 
> There was zero feedback from other core developers, so it's really
> hard to weigh about its acceptance.  My guess is that nobody really
> cares about this thread, which is just the way it is on -hackers for
> some things.  FWIW, I still like what I've done in this patch and this
> design.

Ok. So let me just leave the idea of avoiding unnecessary cache lookups here.

-- 
regards, Andrei Lepikhov,
pgEdge
Attachment

pgsql-hackers by date:

Previous
From: surya poondla
Date:
Subject: Re: Bug: mdunlinkfiletag unlinks mainfork seg.0 instead of indicated fork+segment
Next
From: Andrey Rachitskiy
Date:
Subject: Re: [PATCH] ternary reloption type