Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qExfo-0005xN-B5 for pgsql-hackers@arkaria.postgresql.org; Thu, 29 Jun 2023 19:51:24 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qExfm-00048W-U3 for pgsql-hackers@arkaria.postgresql.org; Thu, 29 Jun 2023 19:51:22 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qExfm-00047g-Er for pgsql-hackers@lists.postgresql.org; Thu, 29 Jun 2023 19:51:22 +0000 Received: from meldrar.postgresql.org ([2a02:c0:301:0:ffff::31]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qExfh-0019Ut-5R for pgsql-hackers@lists.postgresql.org; Thu, 29 Jun 2023 19:51:21 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Content-Type:In-Reply-To:Subject:References: To:From:MIME-Version:Date:Message-ID:Sender:Reply-To:Cc: Content-Transfer-Encoding:Content-ID:Content-Description; bh=rZ7aFasRWv51hePljpBR/jPwSKnAYGEyXec1ZLfsDJs=; b=442D1XnZyceMfd5np2a+z5d08z DOfsfTPmMqp+xHtjPNA5x5JjhRBsdJnDqJtfdjDcjmPktSyv8rNyiKF3sMjxgMBRxtBaIRUoP6k73 NcRP0WKf2FVqO5BtiH+PqZMhSAMVKkTXdzkoJqr7Vq6Zwpe0VEqCHaB8wMCgVfhPtjST+K8lI824Y zIQ/pvFwHyd222XlGW1jKvPEDi2lnCxudi+euCrCiLz+Gbfhuw7SrqYEsKgXgRlEh+S+a0eKITkaQ ZveeWUszTTMmFh/CbIax5M6/NGvMu0AD92MIEaMFpDCN1diYMIze4TqVlFhppMbFiSFQJv4BWsEtu WogrBdJA==; Received: from [52.119.84.106] (helo=[192.168.88.177]) by meldrar.postgresql.org with esmtpsa (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qExfc-003Hm7-Ma for pgsql-hackers@lists.postgresql.org; Thu, 29 Jun 2023 19:51:14 +0000 Message-ID: <950a26ba-ed90-6b24-3335-05e401739873@postgresql.org> Date: Thu, 29 Jun 2023 15:51:10 -0400 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:102.0) Gecko/20100101 Thunderbird/102.12.0 Content-Language: en-US From: "Jonathan S. Katz" To: PostgreSQL Hackers References: Subject: Re: plan_create_index_workers doesn't account for TOAST In-Reply-To: Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------IPv9LbHl0lYJAKJuI11gH1gL" X-Host-Lookup-Failed: Reverse DNS lookup failed for 52.119.84.106 (failed) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --------------IPv9LbHl0lYJAKJuI11gH1gL Content-Type: multipart/mixed; boundary="------------MHE1ykm372LkeFWrXnnmPMxj"; protected-headers="v1" From: "Jonathan S. Katz" To: PostgreSQL Hackers Message-ID: <950a26ba-ed90-6b24-3335-05e401739873@postgresql.org> Subject: Re: plan_create_index_workers doesn't account for TOAST References: In-Reply-To: --------------MHE1ykm372LkeFWrXnnmPMxj Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 T24gNi8yOS8yMyAxMDoxMiBBTSwgSm9uYXRoYW4gUy4gS2F0eiB3cm90ZToNCj4gSGksDQo+ IA0KPiBwbGFuX2NyZWF0ZV9pbmRleF93b3JrZXJzWzFdIGRvZXMgbm90IGNvbnNpZGVyIHRo ZSBhbW91bnQgb2YgdHVwbGVzIA0KPiBleGlzdGluZyBpbiBUT0FTVCBwYWdlcyB3aGVuIGRl dGVybWluaW5nIHRoZSBudW1iZXIgb2YgcGFyYWxsZWwgd29ya2VycyANCj4gdG8gdXNlIGZv ciBhIGJ1aWxkLiBUaGUgZXN0aW1hdGlvbiBjb21lcyBmcm9tIGVzdGltYXRlX3JlbF9zaXpl WzJdLCANCj4gd2hpY2ggaW4gdGhpcyBjYXNlLCB3aWxsIGp1c3QgdGFrZSB0aGUgdmFsdWUg ZnJvbSByZWwtPnJkX3JlbC0+cmVscGFnZXMuDQo+IA0KPiBXZSBwcm9iYWJseSBkb24ndCBu b3RpY2UgdGhpcyBtdWNoIHdpdGggQi10cmVlcywgZ2l2ZW4gYSBCLXRyZWUgaXMgDQo+IHR5 cGljYWxseSB1c2VkIGZvciBkYXRhIHRoYXQgZG9lcyBub3QgcmVxdWlyZSB0b2FzdGluZy4g SG93ZXZlciwgdGhpcyANCj4gYmVjb21lcyBtb3JlIHZpc2libGUgd2hlbiB3b3JraW5nIG9u IGN1c3RvbSBpbmRleCBhY2Nlc3MgbWV0aG9kcyB0aGF0IA0KPiBpbXBsZW1lbnQgdGhlaXIg b3duIHBhcmFsbGVsIGJ1aWxkIHN0cmF0ZWd5Lg0KPiANCj4gRm9yIGV4YW1wbGUsIHBndmVj dG9yWzNdIHByb3ZpZGVzIGl0cyBvd24gZGF0YSB0eXBlcyBhbmQgaW5kZXggYWNjZXNzIA0K PiBtZXRob2QgZm9yIGluZGV4aW5nIHZlY3RvciBkYXRhLiBWZWN0b3JzIGNhbiBnZXQgcXVp dGUgbGFyZ2UgZmFpcmx5IA0KPiBxdWlja2x5LCBlLmcuIGEgNzY4LWRpbWVuc2lvbmFsIHZl Y3RvciB0YWtlcyB1cCA4ICsgNCo3NjggPSAzMDgwIGJ5dGVzIA0KPiBvbiBkaXNrLCB3aGlj aCBxdWlja2x5IGNsZWFycyB0aGUgZGVmYXVsdCBUT0FTVCB0dXBsZSB0aHJlc2hvbGQuDQo+ IA0KPiBJbiBhIHJlY2VudCBwYXRjaCBwcm9wb3NhbCB0byBhbGxvdyBmb3IgYnVpbGRpbmcg aW5kZXhlcyBpbiBwYXJhbGxlbFs0XSwgDQo+IEkgcGVyZm9ybWVkIGEgZmV3IGV4cGVyaW1l bnRzIG9uIGhvdyBtYW55IHBhcmFsbGVsIHdvcmtlcnMgd291bGQgYmUgDQo+IHNwYXduZWQg d2hlbiBpbmRleGluZyAxLDAwMCwwMDAgKDFNTSkgNzY4LWRpbSB2ZWN0b3JzLCBib3RoIHdp dGggDQo+IEVYVEVETkVEIChkZWZhdWx0KSBhbmQgUExBSU4gc3RvcmFnZS4gSW4gYWxsIGNh c2VzLCBJIGFsbG93ZWQgZm9yIGxlYWRlciANCj4gcGFydGljaXBhdGlvbiwgYnV0IHRoZSBs ZWFkZXIgaXMgbm90IGNvbnNpZGVyZWQgaW4gDQo+IHBsYW5fY3JlYXRlX2luZGV4X3dvcmtl cnMuDQo+IA0KPiBXaXRoIEVYVEVOREVELCBwbGFuX2NyZWF0ZV9pbmRleF93b3JrZXJzIHJl Y29tbWVuZGVkIDIgd29ya2Vycy4gVGhlIA0KPiBidWlsZCB0aW1lIHdhcyB+MnggZmFzdGVy IHRoYW4gdGhlIHNlcmlhbCBidWlsZC4NCj4gDQo+IFdpdGggUExBSU4sIHBsYW5fY3JlYXRl X2luZGV4X3dvcmtlcnMgcmVjb21tZW5kZWQgNCB3b3JrZXJzLiBUaGUgYnVpbGQgDQo+IHRp bWUgd2FzICoqfjNYIGZhc3RlcioqIHRoYW4gdGhlIHNlcmlhbCBidWlsZC4NCj4gDQo+IChJ J3ZlIGJlZW4gZG9pbmcgbW9yZSBkZXRhaWxlZCwgbGVzcyBoYW5kLXdhaXZ5IHBlcmZvcm1h bmNlIHRlc3RpbmcsIGJ1dCANCj4gSSB3YW50ZWQgdG8gcHJvdmlkZSBkaXJlY3Rpb25hbCBu dW1iZXJzIGhlcmUpDQo+IA0KPiBJdCBzZWVtcyBsaWtlIHdlJ3JlIGxlYXZpbmcgc29tZSBw ZXJmb3JtYW5jZSBmb3IgY29sdW1ucyB3aXRoIFRPQVNUZWQgDQo+IGRhdGEgdGhhdCByZXF1 aXJlIGluZGV4aW5nLCBzbyBJIHdhbnRlZCB0byBwcm9wb3NlIGFsbG93aW5nIHRoZSBwYWdl cyBpbiANCj4gVE9BU1RlZCB0YWJsZXMgdG8gYmUgY29uc2lkZXJlZCB3aGVuIHdlJ3JlIHRy eWluZyB0byBpbmRleCBhIGNvbHVtbiB3aXRoIA0KPiBUT0FTVGVkIGF0dHJpYnV0ZXMuDQoN Ckp1c3QgdG8gYWRkIHRvIHRoaXM6IHRoZXJlIGlzIGEgbGV2ZXIgdG8gZ2V0IG1vcmUgcGFy YWxsZWwgd29ya2VycyBieSANCnNldHRpbmcgIm1pbl9wYXJhbGxlbF90YWJsZV9zY2FuX3Np emUiIHRvIGEgbG93ZXIgdmFsdWUsIHdoaWNoIGRvZXMgaGVscCANCmluIHRoaXMgY2FzZS4g SG93ZXZlciwgaXQgZG9lcyBtYXNrIHRoZSBmYWN0IHRoYXQgYSBsYXJnZSBjaHVuayBvZiB0 aGUgDQpkYXRhIHJlcXVpcmVkIHRvIGJ1aWxkIHRoZSBpbmRleCBleGlzdHMgaW4gdGhlIFRP QVNUIHRhYmxlLCB3aGljaCBpcyBub3QgDQppbnR1aXRpdmUgdG8gYSB1c2VyIHdobyByYXJl bHkgaGFzIHRvIHVzZSB0dW5pbmcgcGFyYW1ldGVycy4NCg0KVGhhbmtzLA0KDQpKb25hdGhh bg0KDQo= --------------MHE1ykm372LkeFWrXnnmPMxj-- --------------IPv9LbHl0lYJAKJuI11gH1gL Content-Type: application/pgp-signature; name="OpenPGP_signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="OpenPGP_signature" -----BEGIN PGP SIGNATURE----- wsF5BAABCAAjFiEE+oS2la8r95ogZD/x8QSccp8cZScFAmSd4K4FAwAAAAAACgkQ8QSccp8cZSfF ww//e1NO2mVWnZnsuquPm4zDLN8xnyRL2pKmj3roUoryioV4A4VzmI14VcJ8Tygdx5qlw3Na+4bU ErNI1dev2BwBi73akqAoCifLrABx/ZIleM5Sjiao+c3b/MZOl8yiScFHU0WuT45hFNHzR5RvSA0T m9bsq4H3Wt7vG3/XVamhpJsfWl+pPvni/u2XBlnISBwu7aO6wEwGqL3LIIXZ/PFP9MNI+0OhWKYQ Q7OyTQJfsK7NtEI/ooKB4YFYnkHiKlZ1UxgX/RTTWZdRS+vvxNurnKqCi5uC3JY7+mgUTDOh32x5 D4H8ytsf/wP9oe4SHiMM+5uEhnJX2YSoQ3wQPZjt+/9x45HSGTqP9zb+YbxNRYb1nZrV2mT+5o3X 5HM5k1YO0zaez/iRyq40NkwTcj19o/aX2BQ4pzf2CTde0UhRo/OiIUvj8/bSsezxclD9Pys1H7ne TZ6HRnTQDG0j7u2GTHvzkdxWh5ufHkc2NLz+RG05StTd9CaznOrFUs17sei464MkG6zdcCeJxfOq C6mGuIeIIr3aWj7PCADDhaVfvM/d2BS0ekJHX4FwimUvsl/OFZKELoafMz34hGHtWO/zBCehCf2L ltgwO9SU6pZmEy9JlL4fnIevb9Alptq3om1YNCRZuk2e5OT6bysAkr4MN6w/bdBKDWl+jVZVCHkF jac= =lM9s -----END PGP SIGNATURE----- --------------IPv9LbHl0lYJAKJuI11gH1gL--