Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sLuCE-00HE6G-VU for pgsql-general@arkaria.postgresql.org; Tue, 25 Jun 2024 00:38:06 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sLuCC-00CqiH-Hv for pgsql-general@arkaria.postgresql.org; Tue, 25 Jun 2024 00:38:04 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sLuCC-00Cqi9-7L for pgsql-general@lists.postgresql.org; Tue, 25 Jun 2024 00:38:04 +0000 Received: from ml.sraoss.co.jp ([66.11.59.17]) by makus.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sLuC3-002yAL-Pf for pgsql-general@lists.postgresql.org; Tue, 25 Jun 2024 00:38:02 +0000 Received: from sranhm.sraoss.co.jp (unknown [192.168.174.167]) by osspc26.sraoss.co.jp (Postfix) with ESMTP id B50282F00086; Tue, 25 Jun 2024 09:37:53 +0900 (JST) Received: from localhost (unknown [192.168.176.1]) (using TLSv1.3 with cipher TLS_CHACHA20_POLY1305_SHA256 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (2048 bits) server-digest SHA256) (No client certificate requested) by sranhm.sraoss.co.jp (Postfix) with ESMTPSA id 8BEDD3609CB; Tue, 25 Jun 2024 09:37:53 +0900 (JST) Date: Tue, 25 Jun 2024 09:37:50 +0900 (JST) Message-Id: <20240625.093750.1243120916203808312.t-ishii@sranhm.sra.co.jp.sranhm> To: david.g.johnston@gmail.com Cc: ayushvatsa1810@gmail.com, pgsql-general@lists.postgresql.org Subject: Re: Issue with pgstattuple on Sequences in PostgreSQL From: Tatsuo Ishii In-Reply-To: References: X-Mailer: Mew version 6.8 on Emacs 26.3 Mime-Version: 1.0 Content-Type: Text/Plain; charset=iso-8859-7 Content-Transfer-Encoding: base64 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk PiBPbiBNb25kYXksIEp1bmUgMjQsIDIwMjQsIEF5dXNoIFZhdHNhIDxheXVzaHZhdHNhMTgxMEBn bWFpbC5jb20+IHdyb3RlOg0KPj4NCj4+IEkgd2FzIHJlY2VudGx5IGV4cGxvcmluZyB0aGUgcGdz dGF0dHVwbGUgY29kZSBkaXJlY3RvcnkgYW5kIGZvdW5kIHRoaXMNCj4+IHBpZWNlIG9mIGNvZGU6 IGh0dHBzOi8vZ2l0aHViLmNvbS9wb3N0Z3Jlcy9wb3N0Z3Jlcy9ibG9iL21hc3Rlci9jb250cmli Lw0KPj4gcGdzdGF0dHVwbGUvcGdzdGF0dHVwbGUuYyNMMjU1LUwyNTkuDQo+Pg0KPj4gSXQgaW5k aWNhdGVzIHRoYXQgcGdzdGF0dHVwbGUgc3VwcG9ydHMgcmVsYXRpb25zLCB0b2FzdCB0YWJsZXMs DQo+PiBtYXRlcmlhbGl6ZWQgdmlld3MsIGFuZCBzZXF1ZW5jZXMuDQo+PiBIb3dldmVyLCB3aGVu IEkgZXhlY3V0ZWQgYSBxdWVyeSB3aXRoIGEgc2VxdWVuY2UsIEkgZW5jb3VudGVyZWQgdGhlDQo+ PiBmb2xsb3dpbmcgZXJyb3I6DQo+Pg0KPj4gcG9zdGdyZXM9PiBDUkVBVEUgU0VRVUVOQ0Ugc2Vy aWFsIFNUQVJUIDEwMTsNCj4+IENSRUFURSBTRVFVRU5DRQ0KPj4gcG9zdGdyZXM9PiBTRUxFQ1Qg KiBGUk9NIHBnc3RhdHR1cGxlKCdzZXJpYWwnKTsNCj4+IEVSUk9SOiAgb25seSBoZWFwIEFNIGlz IHN1cHBvcnRlZA0KPj4gcG9zdGdyZXM9Pg0KPj4NCj4+IEl0IGdvdCBzdHVjayBpbiB0aGlzIGlm IGNvbmRpdGlvbiAtIGh0dHBzOi8vZ2l0aHViLmNvbS9wb3N0Z3Jlcy8NCj4+IHBvc3RncmVzL2Js b2IvbWFzdGVyL2NvbnRyaWIvcGdzdGF0dHVwbGUvcGdzdGF0dHVwbGUuYyNMMzI2LUwzMjkNCj4+ DQo+Pg0KPj4gSG93IGNhbiBvbmUgdXNlIHBnc3RhdHR1cGxlIG9uIHNlcXVlbmNlcz8NCj4+DQo+ IA0KPiBBcy1pcz8gIERvZXNuonQgbG9vayBsaWtlIHlvdSBjYW4uDQoNCkl0IHVzZWQgdG8gd29y ayB1bnRpbCB2MTEuDQoNCnRlc3Q9IyBTRUxFQ1QgKiBGUk9NIHBnc3RhdHR1cGxlKCdzZXJpYWwn KTsNCi1bIFJFQ09SRCAxIF0tLS0tLS0rLS0tLS0tDQp0YWJsZV9sZW4gICAgICAgICAgfCA4MTky DQp0dXBsZV9jb3VudCAgICAgICAgfCAxDQp0dXBsZV9sZW4gICAgICAgICAgfCA0MQ0KdHVwbGVf cGVyY2VudCAgICAgIHwgMC41DQpkZWFkX3R1cGxlX2NvdW50ICAgfCAwDQpkZWFkX3R1cGxlX2xl biAgICAgfCAwDQpkZWFkX3R1cGxlX3BlcmNlbnQgfCAwDQpmcmVlX3NwYWNlICAgICAgICAgfCA4 MTA0DQpmcmVlX3BlcmNlbnQgICAgICAgfCA5OC45Mw0KDQpJdCBzdG9wcGVkIHdvcmtpbmcgYnkg dGhpcyBjb21taXQ6DQoNCmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL2dpdHdlYi8/cD1wb3N0 Z3Jlc3FsLmdpdDthPWNvbW1pdDtoPTRiODI2NjQxNTZjMjMwYjU5NjA3NzA0NTA2ZjViMGEzMmVm NDkwYTINCg0KYmVjYXVzZSBwZ3N0YXRfaGVhcCgpIHJlamVjdHMgb3RoZXIgdGhhbiBoZWFwIEFN LiAgSSB0aGluayB0aGUgdjEyDQpyZWxlYXNlIG5vdGUgc2hvdWxkIGhhdmUgZXhwbGljaXRseSBt ZW50aW9uZWQgdGhhdCBzZXF1ZW5jZXMgYXJlIG5vdA0Kc3VwcG9ydGVkIGJ5IHBnc3RhdHR1cGxl IGFueSBtb3JlLg0KDQo+IEkgYWdyZWUgaXSicyBhIGRvY3VtZW50YXRpb24gYnVnIHRoYXQNCj4g dGhpcyBpcyB0aGUgY2FzZSB3aXRoIGEgYnJpZWYgZXhwbGFuYXRpb24gb2Ygd2h5IC0gc2VxdWVu Y2VzIGRvIG5vdCBwcm9kdWNlDQo+IGRlYWQgdHVwbGVzIGFuZCBkbyBub3QgYmVoYXZlIGxpa2Ug cmVhbCB0YWJsZXMgYXNpZGUgZnJvbSBiZWluZyBhYmxlIHRvIGJlDQo+IHNlbGVjdGVkIGZyb20g KGkuZS4sIG5vIFNRTCB1cGRhdGUvZGVsZXRlIGNvbW1hbmQpLg0KPiANCj4gVGhlIGNvZGUgc2hv dWxkIHByb2R1Y2UgYW4gZXhwbGljaXQgZXJyb3IgZm9yIHRoYXQgcmVsa2luZCBhcyB3ZWxsLg0K DQpJZiBzbywgdGhlbiB0aGUgcmVncmVzc2lvbiB0ZXN0IHNob3VsZCBiZSBmaXhlZCBhcyB3ZWxs LiBDdXJyZW50bHkNCnRoZXJlJ3Mgbm8gdGVzdCBjYXNlIGZvciBzZXF1ZW5jZXMuDQoNCkJlc3Qg cmVhZ2FyZHMsDQotLQ0KVGF0c3VvIElzaGlpDQpTUkEgT1NTIExMQw0KRW5nbGlzaDogaHR0cDov L3d3dy5zcmFvc3MuY28uanAvaW5kZXhfZW4vDQpKYXBhbmVzZTpodHRwOi8vd3d3LnNyYW9zcy5j by5qcA0K