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 1sZB1g-00GuMV-Em for pgsql-committers@arkaria.postgresql.org; Wed, 31 Jul 2024 15:14:04 +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 1sZB1e-008uS3-UG for pgsql-committers@arkaria.postgresql.org; Wed, 31 Jul 2024 15:14:02 +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 1sZB1e-008uRv-L1 for pgsql-committers@lists.postgresql.org; Wed, 31 Jul 2024 15:14:02 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sZB1b-002OdP-Ki for pgsql-committers@lists.postgresql.org; Wed, 31 Jul 2024 15:14:01 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Date:Message-Id:Subject:To:From:MIME-Version: Content-Type:Sender:Reply-To:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=8kZr4O8u52+REiCWTC2EyVAGqV+sF3lPJXnZ7lngNYQ=; b=j68v+SjJie7Cyxj4uP3r9Vg8gZ e1AXZ4aabVVsFYtVSbwtOOInCfH7SUkphy+MSwLpK/vIxdTPYZURPoRZmg3pJFSjymvCtaU0nhz0S PViS92WUuhct9UG9ie/vcdr4jcdjTLen8YmKd5c/4TGc4JG2HsdtEDQwLNyGALdbYrAs0s/AiC2D/ f0ICSLOsvbLzTOzBQ1KtGl3YC30U6fVRELY0BYlppS8v0HEeVbnHSNfenoJ9Bja6FdN8/90/hIjcy T7SRdCRxDVuLa4Nn1JLCLV/L4sAcuIJYux9CAZH/+Zr6MvJJcEpe70caSbBj4MpAiW5v18Cmt8QXk MwJUQzqw==; Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sZB1a-007Td6-MK for pgsql-committers@lists.postgresql.org; Wed, 31 Jul 2024 15:13:58 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sZB1a-0023GV-0J for pgsql-committers@lists.postgresql.org; Wed, 31 Jul 2024 15:13:58 +0000 Content-Type: multipart/mixed; boundary="===============0890657737149418185==" MIME-Version: 1.0 From: Nathan Bossart To: pgsql-committers@lists.postgresql.org Subject: pgsql: Improve performance of dumpSequence(). X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Wed, 31 Jul 2024 15:13:58 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============0890657737149418185== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 SW1wcm92ZSBwZXJmb3JtYW5jZSBvZiBkdW1wU2VxdWVuY2UoKS4KClRoaXMgZnVuY3Rpb24gZHVt cHMgdGhlIHNlcXVlbmNlIGRlZmluaXRpb25zLiAgSXQgaXMgY2FsbGVkIG9uY2UKcGVyIHNlcXVl bmNlLCBhbmQgZWFjaCBzdWNoIGNhbGwgZXhlY3V0ZXMgYSBxdWVyeSB0byByZXRyaWV2ZSB0aGUK bWV0YWRhdGEgZm9yIGEgc2luZ2xlIHNlcXVlbmNlLiAgVGhpcyBjYW4gY2F1c2UgcGdfZHVtcCB0 byB0YWtlCnNpZ25pZmljYW50bHkgbG9uZ2VyLCBlc3BlY2lhbGx5IHdoZW4gdGhlcmUgYXJlIG1h bnkgc2VxdWVuY2VzLgoKVGhpcyBjb21taXQgaW1wcm92ZXMgdGhlIHBlcmZvcm1hbmNlIG9mIHRo aXMgZnVuY3Rpb24gYnkgZ2F0aGVyaW5nCmFsbCB0aGUgc2VxdWVuY2UgbWV0YWRhdGEgd2l0aCBh IHNpbmdsZSBxdWVyeSBhdCB0aGUgYmVnaW5uaW5nIG9mCnBnX2R1bXAuICBUaGlzIGluZm9ybWF0 aW9uIGlzIHN0b3JlZCBpbiBhIHNvcnRlZCBhcnJheSB0aGF0CmR1bXBTZXF1ZW5jZSgpIGNhbiBi c2VhcmNoKCkgZm9yIHdoYXQgaXQgbmVlZHMuICBUaGlzIGZvbGxvd3MgYQpzaW1pbGFyIGFwcHJv YWNoIGFzIGNvbW1pdHMgZDVlODkzMGY1MCBhbmQgMjMyOWNhZDFiOSwgd2hpY2gKaW50cm9kdWNl ZCBzb3J0ZWQgYXJyYXlzIGZvciByb2xlIGluZm9ybWF0aW9uIGFuZCBwZ19jbGFzcwppbmZvcm1h dGlvbiwgcmVzcGVjdGl2ZWx5LiAgQXMgd2l0aCB0aG9zZSBjb21taXRzLCB0aGlzIHBhdGNoIHdp bGwKY2F1c2UgcGdfZHVtcCB0byB1c2UgbW9yZSBtZW1vcnksIGJ1dCB0aGF0IGlzbid0IGV4cGVj dGVkIHRvIGJlIHRvbwplZ3JlZ2lvdXMuCgpOb3RlIHRoYXQgYmVmb3JlIHZlcnNpb24gMTAsIHRo ZSBzZXF1ZW5jZSBtZXRhZGF0YSB3YXMgc3RvcmVkIGluCnRoZSBzZXF1ZW5jZSByZWxhdGlvbiBp dHNlbGYsIHdoaWNoIG1ha2VzIGl0IGRpZmZpY3VsdCB0byBnYXRoZXIKYWxsIHRoZSBzZXF1ZW5j ZSBtZXRhZGF0YSB3aXRoIGEgc2luZ2xlIHF1ZXJ5LiAgRm9yIHRob3NlIG9sZGVyCnZlcnNpb25z LCB3ZSBjb250aW51ZSB0byB1c2UgdGhlIHByZWV4aXN0aW5nIHF1ZXJ5LXBlci1zZXF1ZW5jZQph cHByb2FjaC4KClJldmlld2VkLWJ5OiBFdWxlciBUYXZlaXJhCkRpc2N1c3Npb246IGh0dHBzOi8v cG9zdGdyLmVzL20vMjAyNDA1MDMwMjUxNDAuR0ExMjI3NDA0JTQwbmF0aGFueHBzMTMKCkJyYW5j aAotLS0tLS0KbWFzdGVyCgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQucG9zdGdyZXNxbC5v cmcvcGcvY29tbWl0ZGlmZi82OGU5NjI5OTg1OTgxY2U4ZjhmMDRiNWE5ZjhiMzc4MWVhY2FhZmQ2 CgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpzcmMvYmluL3BnX2R1bXAvcGdfZHVtcC5j ICAgICAgICB8IDE3NSArKysrKysrKysrKysrKysrKysrKysrKysrKysrLS0tLS0tLS0tLS0Kc3Jj L3Rvb2xzL3BnaW5kZW50L3R5cGVkZWZzLmxpc3QgfCAgIDEgKwoyIGZpbGVzIGNoYW5nZWQsIDEy OSBpbnNlcnRpb25zKCspLCA0NyBkZWxldGlvbnMoLSkKCg== --===============0890657737149418185==--