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 1sWetd-00GWdX-2M for pgsql-committers@arkaria.postgresql.org; Wed, 24 Jul 2024 16:31:21 +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 1sWetb-006LMs-IP for pgsql-committers@arkaria.postgresql.org; Wed, 24 Jul 2024 16:31:19 +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 1sWetb-006LMj-AS for pgsql-committers@lists.postgresql.org; Wed, 24 Jul 2024 16:31:19 +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-001FuA-BF for pgsql-committers@lists.postgresql.org; Wed, 24 Jul 2024 16:31:18 +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=CJLf5m91YPnPmHQzQHjXMQy9HjZlxEyC8LNatw8iAhM=; b=Jap/etnvvaA19C7YNaxt/KjrOj CsiWketOte19SYqFPCYLZdn8I4A+IiJVz+oaBECYX702BSCtTEL4CZ2ykNLQVM4MPiZkp2LUb9JXZ 6WNUstD8M7OSdRfAPXAIeBj3FPjgiQCKnSir9dNKcIgsoIxK6IjEKICffn+iSphpdM/prOr3aO9OJ XnIyOf9LNwdNQkwPUI4gl7YwPG91WjwnT7QCkcDpvmPUPC4JUjrPRMmkPLyv0izRdM34xCnOf+1pV d/4991TKw0P8jSUoWJGhCsQJvb9xbBZitYa6TNR6HmMAGruFGcYcTMBJjTVxlbE9L7GQ1lSRhdiwt YWNVRZPQ==; 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 1sWetW-003us2-TR for pgsql-committers@lists.postgresql.org; Wed, 24 Jul 2024 16:31:14 +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-0011gV-DJ for pgsql-committers@lists.postgresql.org; Wed, 24 Jul 2024 16:31:14 +0000 Content-Type: multipart/mixed; boundary="===============8546384488902905297==" 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 --===============8546384488902905297== 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 dGNoLXRocm91Z2g6IDE3CgpCcmFuY2gKLS0tLS0tClJFTF8xN19TVEFCTEUKCkRldGFpbHMKLS0t LS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmLzczZGU1MGUxM2Uz OTdkYThlOThlZDU5YjBmZTYzYTAwMDUxYTcxMjgKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0t LS0tCnNyYy9iaW4vcGdfdXBncmFkZS9jaGVjay5jICAgICAgfCAxMyArKysrKy0tLS0tLQpzcmMv YmluL3BnX3VwZ3JhZGUvaW5mby5jICAgICAgIHwgNTEgKysrKysrLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0Kc3JjL2Jpbi9wZ191cGdyYWRlL3BnX3VwZ3JhZGUuaCB8ICA0ICsr LS0KMyBmaWxlcyBjaGFuZ2VkLCAxNSBpbnNlcnRpb25zKCspLCA1MyBkZWxldGlvbnMoLSkKCg== --===============8546384488902905297==--