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 1sWetz-00GWfC-U5 for pgsql-committers@arkaria.postgresql.org; Wed, 24 Jul 2024 16:31:43 +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 1sWety-006MI2-EC for pgsql-committers@arkaria.postgresql.org; Wed, 24 Jul 2024 16:31:42 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sWetc-006LWB-OX for pgsql-committers@lists.postgresql.org; Wed, 24 Jul 2024 16:31:20 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sWetY-001FuB-C4 for pgsql-committers@lists.postgresql.org; Wed, 24 Jul 2024 16:31:19 +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=efMQWWcNLXvsWSEmR1OwEnd3t7YMEM2YlFfecepHPng=; b=SYm59zbYWhDJKC/LnULiktnLy8 zqIDP+qqfhPm5NsnlS8pn3DMoCdfjySSC4XxqloR0BFfbYE9nAXkkLDqHyAABbL2mLg+2UMRRkc4J 9+djMj814lOkW8bD3MhURfSS/MDlBaaNzCqVA+ekchOnV0tlX733sVIIlItpzjgU8/A2NDZTRU+U5 njBKhXeqfmDmOmDNTYqExUmMgjjjn7nlJWekLLiC91iIvekrgK/vWRSGTL1RE3ui73ktHLL3CKEoU pu09kdUPeQONjDEX33LJvLIK28TPT6e/zsLRMNGu1spwghGxsN7ni1sGMCzB+eG6YH5YWqr24o5BA hYGDqj9g==; 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 1sWetX-003us1-14 for pgsql-committers@lists.postgresql.org; Wed, 24 Jul 2024 16:31:15 +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 1sWetW-0011gU-CL for pgsql-committers@lists.postgresql.org; Wed, 24 Jul 2024 16:31:14 +0000 Content-Type: multipart/mixed; boundary="===============3914168552231430736==" MIME-Version: 1.0 From: Nathan Bossart To: pgsql-committers@lists.postgresql.org Subject: pgsql: pg_upgrade: Retrieve subscription count more efficiently. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Wed, 24 Jul 2024 16:31:14 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============3914168552231430736== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 cGdfdXBncmFkZTogUmV0cmlldmUgc3Vic2NyaXB0aW9uIGNvdW50IG1vcmUgZWZmaWNpZW50bHku CgpQcmVzZW50bHksIHBnX3VwZ3JhZGUgb2J0YWlucyB0aGUgbnVtYmVyIG9mIHN1YnNjcmlwdGlv bnMgaW4gdGhlCnRvLWJlLXVwZ3JhZGVkIGNsdXN0ZXIgYnkgZmlyc3QgcXVlcnlpbmcgcGdfc3Vi c2NyaXB0aW9uIGluIGV2ZXJ5CmRhdGFiYXNlIGZvciB0aGUgbnVtYmVyIG9mIHN1YnNjcmlwdGlv bnMgaW4gb25seSB0aGF0IGRhdGFiYXNlLgpUaGVuLCBpbiBjb3VudF9vbGRfY2x1c3Rlcl9zdWJz Y3JpcHRpb25zKCksIGl0IGFkZHMgYWxsIHRoZSB2YWx1ZXMKY29sbGVjdGVkIGluIHRoZSBmaXJz dCBzdGVwLiAgVGhpcyBpcyBleHBlbnNpdmUsIGVzcGVjaWFsbHkgd2hlbgp0aGVyZSBhcmUgbWFu eSBkYXRhYmFzZXMuCgpGb3J0dW5hdGVseSwgdGhlcmUgaXMgYSBiZXR0ZXIgd2F5IHRvIHJldHJp ZXZlIHRoZSBzdWJzY3JpcHRpb24KY291bnQuICBTaW5jZSBwZ19zdWJzY3JpcHRpb24gaXMgYSBz aGFyZWQgY2F0YWxvZywgd2Ugb25seSBuZWVkIHRvCmNvbm5lY3QgdG8gYSBzaW5nbGUgZGF0YWJh c2UgYW5kIHF1ZXJ5IGl0IG9uY2UuICBUaGlzIGNvbW1pdAptb2RpZmllcyBwZ191cGdyYWRlIHRv IHVzZSB0aGF0IGFwcHJvYWNoLCB3aGljaCBhbHNvIGFsbG93cyB1cyB0bwp0cmltIHNldmVyYWwg bGluZXMgb2YgY29kZS4gIEluIHBhc3NpbmcsIG1vdmUgdGhlIGNhbGwgdG8KZ2V0X2RiX3N1YnNj cmlwdGlvbl9jb3VudCgpLCB3aGljaCBoYXMgYmVlbiByZW5hbWVkIHRvCmdldF9zdWJzY3JpcHRp b25fY291bnQoKSwgZnJvbSBnZXRfZGJfcmVsX2FuZF9zbG90X2luZm9zKCkgdG8gdGhlCmRlZGlj YXRlZCA+PSB2MTcgc2VjdGlvbiBpbiBjaGVja19hbmRfZHVtcF9vbGRfY2x1c3RlcigpLgoKV2Ug bWF5IGJlIGFibGUgdG8gbWFrZSBzaW1pbGFyIGltcHJvdmVtZW50cyB0bwpnZXRfb2xkX2NsdXN0 ZXJfbG9naWNhbF9zbG90X2luZm9zKCksIGJ1dCB0aGF0IGlzIGxlZnQgYXMgYSBmdXR1cmUKZXhl cmNpc2UuCgpSZXZpZXdlZC1ieTogTWljaGFlbCBQYXF1aWVyLCBBbWl0IEthcGlsYQpEaXNjdXNz aW9uOiBodHRwczovL3Bvc3Rnci5lcy9tL1pwclFKdl9UeGNjTjN0a3IlNDBuYXRoYW4KQmFja3Bh dGNoLXRocm91Z2g6IDE3CgpCcmFuY2gKLS0tLS0tCm1hc3RlcgoKRGV0YWlscwotLS0tLS0tCmh0 dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvMzY0NTA5YTJlN2Y5Mjc4NTQw NzM0OGVjNzAyZTM5NzI5ZmRhNmNmOAoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0Kc3Jj L2Jpbi9wZ191cGdyYWRlL2NoZWNrLmMgICAgICB8IDEzICsrKysrLS0tLS0tCnNyYy9iaW4vcGdf dXBncmFkZS9pbmZvLmMgICAgICAgfCA1MSArKysrKystLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLQpzcmMvYmluL3BnX3VwZ3JhZGUvcGdfdXBncmFkZS5oIHwgIDQgKystLQozIGZp bGVzIGNoYW5nZWQsIDE1IGluc2VydGlvbnMoKyksIDUzIGRlbGV0aW9ucygtKQoK --===============3914168552231430736==--