Content-Type: multipart/mixed; boundary="------------cTpUhB3wDQT6gz0wCl4r2KCB"
Message-ID: <e10e3067-9e95-40f0-be84-de59787bf742@gmail.com>
Date: Mon, 18 May 2026 20:42:51 +0200
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Sequence Access Methods, round two
To: Michael Paquier <michael@paquier.xyz>
Cc: Postgres hackers <pgsql-hackers@lists.postgresql.org>,
 Xuneng Zhou <xunengzhou@gmail.com>, Chao Li <li.evan.chao@gmail.com>,
 Peter Eisentraut <peter@eisentraut.org>,
 Kirill Reshke <reshkekirill@gmail.com>, Peter Smith <smithpb2250@gmail.com>
References: <02699E3C-CC8B-423D-B36F-0AAA9370415E@gmail.com>
 <aUpWDj1yr3osMbhO@paquier.xyz>
 <1F653C1D-A28D-4F3B-8B18-98F993F39B04@gmail.com>
 <433EABEB-0BBB-46E6-B2D2-226E9494A6D8@gmail.com>
 <aU4g6YY_zmVKhmub@paquier.xyz>
 <4317C0A5-2210-40C1-93FE-FF618E3BC0D4@gmail.com>
 <aV3v-mFzKmOPoz7g@paquier.xyz>
 <688decf8-1e14-4ebc-869f-94e9ce6b53db@gmail.com>
 <agj5RCIn0e62V1KA@paquier.xyz>
 <8e63b447-9ebb-4873-973b-437b20c49881@gmail.com>
 <agpElslHL2UQ6oxJ@paquier.xyz>
Content-Language: en-US
From: Andrei Lepikhov <lepihov@gmail.com>
In-Reply-To: <agpElslHL2UQ6oxJ@paquier.xyz>
Archived-At: 
 <https://www.postgresql.org/message-id/e10e3067-9e95-40f0-be84-de59787bf742%40gmail.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------cTpUhB3wDQT6gz0wCl4r2KCB
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit

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
--------------cTpUhB3wDQT6gz0wCl4r2KCB
Content-Type: text/plain; charset=UTF-8; name="wire_local_seq.diff"
Content-Disposition: attachment; filename="wire_local_seq.diff"
Content-Transfer-Encoding: base64

ZGlmZiAtLWdpdCBhL3NyYy9iYWNrZW5kL3V0aWxzL2NhY2hlL3JlbGNhY2hlLmMgYi9zcmMv
YmFja2VuZC91dGlscy9jYWNoZS9yZWxjYWNoZS5jCmluZGV4IDJhOGU2NGM3Mjc5Li4xYzIx
OWNlMzE5ZCAxMDA2NDQKLS0tIGEvc3JjL2JhY2tlbmQvdXRpbHMvY2FjaGUvcmVsY2FjaGUu
YworKysgYi9zcmMvYmFja2VuZC91dGlscy9jYWNoZS9yZWxjYWNoZS5jCkBAIC0xODcyLDEy
ICsxODcyLDI0IEBAIFJlbGF0aW9uSW5pdFNlcXVlbmNlQWNjZXNzTWV0aG9kKFJlbGF0aW9u
IHJlbGF0aW9uKQogCU9pZAkJCXRhYmxlYW1faGFuZGxlcjsKIAogCUFzc2VydChSRUxLSU5E
X0hBU19TRVFVRU5DRV9BTShyZWxhdGlvbi0+cmRfcmVsLT5yZWxraW5kKSk7CisJQXNzZXJ0
KHJlbGF0aW9uLT5yZF9yZWwtPnJlbGFtICE9IEludmFsaWRPaWQpOwogCiAJLyoKLQkgKiBM
b29rIHVwIHRoZSBzZXF1ZW5jZSBhY2Nlc3MgbWV0aG9kLCBzYXZlIHRoZSBPSUQgb2YgaXRz
IGhhbmRsZXIKLQkgKiBmdW5jdGlvbi4KKwkgKiBGYXN0IHBhdGggZm9yIHRoZSBidWlsdC1p
biAic2VxbG9jYWwiIEFNOiBhdm9pZCB0d28gc3lzY2FjaGUgbG9va3VwcworCSAqIGFuZCBh
IG5hbWUtYmFzZWQgcGdfYW0gc2NhbiBvbiBldmVyeSBjb2xkLWNhY2hlIG9wZW4gb2YgYSBz
ZXF1ZW5jZQorCSAqIHVzaW5nIHRoZSBkZWZhdWx0IGFjY2VzcyBtZXRob2QuCisJICoKKwkg
KiBUaGlzIG1pcnJvcnMgdGhlIGNhdGFsb2ctcmVsYXRpb24gZmFzdCBwYXRoIGluCisJICog
UmVsYXRpb25Jbml0VGFibGVBY2Nlc3NNZXRob2QoKSBhYm92ZS4KIAkgKi8KLQlBc3NlcnQo
cmVsYXRpb24tPnJkX3JlbC0+cmVsYW0gIT0gSW52YWxpZE9pZCk7CisJaWYgKHJlbGF0aW9u
LT5yZF9yZWwtPnJlbGFtID09IExPQ0FMX1NFUVVFTkNFX0FNX09JRCkKKwl7CisJCXJlbGF0
aW9uLT5yZF9hbWhhbmRsZXIgPSBGX1NFUV9MT0NBTF9TRVFVRU5DRUFNX0hBTkRMRVI7CisJ
CXJlbGF0aW9uLT5yZF9zZXF1ZW5jZWFtID0gR2V0U2VxdWVuY2VBbVJvdXRpbmUocmVsYXRp
b24tPnJkX2FtaGFuZGxlcik7CisJCXJlbGF0aW9uLT5yZF90YWJsZWFtID0gR2V0VGFibGVB
bVJvdXRpbmUoRl9IRUFQX1RBQkxFQU1fSEFORExFUik7CisJCXJldHVybjsKKwl9CisKIAly
ZWxhdGlvbi0+cmRfYW1oYW5kbGVyID0gR2V0U2VxdWVuY2VBbVJvdXRpbmVJZChyZWxhdGlv
bi0+cmRfcmVsLT5yZWxhbSk7CiAKIAkvKgo=

--------------cTpUhB3wDQT6gz0wCl4r2KCB--