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 1slvYc-0020g3-Q5 for pgsql-hackers@arkaria.postgresql.org; Wed, 04 Sep 2024 19:20:47 +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 1slvYa-00E4ZS-73 for pgsql-hackers@arkaria.postgresql.org; Wed, 04 Sep 2024 19:20:44 +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 1slvYZ-00E4Pk-OT for pgsql-hackers@lists.postgresql.org; Wed, 04 Sep 2024 19:20:44 +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 1slvYX-0009uf-4G for pgsql-hackers@lists.postgresql.org; Wed, 04 Sep 2024 19:20:42 +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:From:References:Cc: To:Subject:MIME-Version:Date:Message-ID:Sender:Reply-To: Content-Transfer-Encoding:Content-ID:Content-Description; bh=/MmptRqjQwV3P0QXDL+JD+M1bn8E4P7iE7/CGEduGig=; b=IS6MXXYc3CqG6aUMZEpoSYRymI AX/eDp0CYz7l+rMy4Zf75l/7MIPOpBvJM1KGTZTMMuOGp/ucA5SlcJOr0VGiCfrG+uNPccn99RsEW VA+/pHhNkGF5YntFQAZexlQX8b5/XAcuC5WQUIl4kTGjJmcratuLKkvzEndKkoaYhX8KsPWkFRQOu H65xXfYxlCqN9fDYXrjBd8ZuMaDD30uYcSDXv5bUNI7Zh/I0yK/nbnCBh9Ze1BI+q1PCBEMXjn3BU ujr3KHEgqcv8CxyMcqyV0xaoa9a5kybIjnnWVLlfH6EEEkpuRxAtF/sAuGuED4TmZgTDgeKMEVtoj j9JFB7hA==; Received: from [52.119.84.39] (helo=[192.168.88.172]) by meldrar.postgresql.org with esmtpsa (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1slvYR-000Nwe-PA; Wed, 04 Sep 2024 19:20:38 +0000 Message-ID: Date: Wed, 4 Sep 2024 15:20:33 -0400 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Large expressions in indexes can't be stored (non-TOASTable) To: Tom Lane , Nathan Bossart Cc: PostgreSQL Hackers References: <1679756.1725476893@sss.pgh.pa.us> Content-Language: en-US From: "Jonathan S. Katz" Autocrypt: addr=jkatz@postgresql.org; keydata= xsFNBFtShwABEAC7PNHDUOTYuifpUCk23KqfxdQQkn4nkoxOXRK0+rAj36FiwqGB4TJFuOVZ sDFAEiSlC8Jt4y5Cs7B5tetT8JNd2cs6zp/udMJJDz9d65O9PDpdlMgAmIiTzpLlSdx8FG56 DTksaDv1d8j3cTJPSE4/fWSxqzA7o3Y9UuL7atZPrzfImgpRKs0of7elIHwOa8GucjyhYqcR h60wFBJc2KXqQdDYRTZy43DSnY/0VNc0omiH355fustvpm+m5HjD3w7qZyfN3fpKJpnX1LCF f3MnPHaDGITIYGRCBXvf0UqUtD6OEVWPv2C2gyqWMIpWmZTOgDufltKyIByKBoS9x0PlFkij 04X3KODCngt+N8Ssc9OICc6QSxhjoP48PYPdmiTmkrGuf0LX084wj1xeo1NX7XxZK39F6dTJ DhsIiW0sNS0xMxQHLHG9VLbPjx3SANQBh6BuryPz5ZupW9/TIDmkvprtU/oXfKgtfYm3fxmk EctxbWrEPsFTFPyuMqQu6l+xyQv0s1VLZfjNWaua6H1/gGoIt6kRnn5qMXDVVpijuWkHbv7G ngaQMd258UrrOEHnnjzhQ7jxMWV9D+emxbAtlIxnYvCWlV4IwAQhEHfvudqYaIY3hNWrvQ6H GB2KXoTZYN9g5djm14/5nj1IU5zOcovkjJnKhoo9iStnpFF2cwARAQABzSdKb25hdGhhbiBT LiBLYXR6IDxqa2F0ekBwb3N0Z3Jlc3FsLm9yZz7CwY4EEwEIADgCGwMFCwkIBwIGFQoJCAsC BBYCAwECHgECF4AWIQT6hLaVryv3miBkP/HxBJxynxxlJwUCYvBxpgAKCRDxBJxynxxlJ/Us EACe5W9aBAJGdFjbHc+yEy/0UVcDhDeNeJC8vGuyuMwj6cZgm8HmVddaGKWaumaDziOnGj5B zBUB9cZBPuM+j8Gli2F5hdSTeLZseHqNtuj2sGpTaZ+6utCt3iMIh+ZrHq2ufqMj9m6uA93+ SziFGcA+8+qKFTjqTUgZUxEgLnInk9191NaQT/LiH34JRlFY009XIQWRfDBYB8kJHpDQbp9y 9gsyzgYEMO4bxsXgD4BeHKW+s9OmP/zlDyHOLtyrsXLZHZA42TR/tnSTTwC9Xcx99eh5AS+u t1orACYzZfTEWph2of8AI0cuAT3c3MZNw7ypLcejr/Y71wAXQeiC55ZKrx6rsmsICXohx8be l0Lsnm+oHqSzfbVxZe/2teHLfaupD4P1OPnM9ljeqvIyhvHFlrc6LUHzMv0jf97TUCcWmmo9 qWmzT8wFkSDbFMj5Vk0hJ/nexipTqTzWQo5G9yN6aUDiOBDTvWeMGAvso01/11M/Tf7Ouq/S kcHFhpZgm7EzakFrmMD1l0DsyXUM4AtErvEC/4M5ZMNvwmvXUC3ndrSv00k3wrtQ2t9OGT4h NciB7uqiU+DrxoEZHx+AUC0MhKE96E3KQ+XYjUHfVr+ribl/2oiwazdCjVrkVyKoyMs5IQ1X gaOhxsLp2uBCdzQqMOmGxplc+K03KhJZ6TiU9s7BTQRbUocAARAAv8ho/toQ9DG3j4f9h9n1 aRHr2FlviN2Utpy6L8+dfDggO0geilmkGQOolZ2E60gGfye/kUtF9W3NByO4hxDR9u6qbOXc dqnuA+cc68EfqlWFJrVtYFxt0h4ElWYOYnIezKthriWch/FY70FGrxs3z8UHOHq50wBW433e TvZm90WixBiXEt2v1DgW4Vr3ymfO7Aap/IYyPuE4JzgudAuAl0HKPyNEHWHG1dAbjX1RiCw9 gknIDWQOF0B4UAaJctWGVcnZ3A2ULwNGMa1P9ZJlBWf1vcj01aiHMU0yQ7JjJiSpvfm9eM0u SLwRdDrJjyl5ZZqVumjdv2SMNQ8GvYRbEMys3GGDSt9zXgfCSUnPnJfYxjzBHRI6x44Wfsx8 S6hWxepOogCJJ/g67Bk9mY8YV4klWIXDJVOL5jnBC09DbsZG81JaE2QxB8Y7W36ZMroi9XMx g3s805hQAQUvdG/poU8hN8BWdrnTm/+4eQQp7gDY1ePDmGM6bJC+OHOSnFtR/f+70zpKJ10c c7cBygGnl1yR3KjhFyAWUFvP4ZGziKCcpMwXZfe9PGuyA/YOubMphxIn3YsK2wrdfaKZYX2G MZCZhMMcvx9IpQrxIJgU+VlwXu/O+Lk10VIPcxPJJwmpdI6HzcS8ZgG6IMcC444XXTuLaP8j 2mgcMvYak3ScCykAEQEAAcLBdgQYAQgAIBYhBPqEtpWvK/eaIGQ/8fEEnHKfHGUnBQJi8HGn AhsMAAoJEPEEnHKfHGUneVcQALCswm06CgJjQ+lFmjYaw/OFZ9LJgHbaqGrfyNmjIXOhRiqt 65VWmC8/yetWCfLtXzCsPrQGXjon1IuKZUfcvVQ39lh8apvfUweNWH9xCpHkWmai8rKbjTkd 0YXyK9dYVPw7ATKSpMzM61QvPIndjQ7iTT1SnCINj7zMDuMSuyiTUGr57VmXzFW466BJ/XGg P5+mLYrbjpbsB0ByUbral6XBs57LYSRFzQ17SekWlAlFSlW6xTCdKq7VKYd+Utb8N7uXejNG qjDCXmcPB45+pYC9ckSKyWceFpSqjO7OzMK8Q1OfGIAuQQ3UegGefuhIV06mWXsrgLOGSbM8 ZH9GT1OxkFiDneSSCmjHRzTWgPSH7c/9r5cG5Uo5GIfVDIgirhcgKwUgullb2r3vZDBRKi9N 44NeTkaE7KdfEkziDhe96OMdrCLnH4Kt2Gcgc4R/sibjqtvxX/YvmaiimK1H6fa74sstqSlZ w8Jbr9hQvk0P4UzySrlmsuOGwHodeM8R/Tklke6AJkYANcyP4r8xRfAe/pTH7zz4usdlncgP Z/WieSo1zvU6VEh6TAwakocfUDIcpqSxcZAs2pfjjNz+owqoFWMbn6BEO0J0xX65p//J9vd3 LZLjN6yBvXCRDoSD+B85thpxQSoI+jXC8d7DiejNLaHqxkgUeyfq9n99cyl3 In-Reply-To: <1679756.1725476893@sss.pgh.pa.us> Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------ewDPmK0Mo4Qao38l3MhiZQnk" X-Host-Lookup-Failed: Reverse DNS lookup failed for 52.119.84.39 (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) --------------ewDPmK0Mo4Qao38l3MhiZQnk Content-Type: multipart/mixed; boundary="------------0wXM9NCWf93kk9AdITXvnXFN"; protected-headers="v1" From: "Jonathan S. Katz" To: Tom Lane , Nathan Bossart Cc: PostgreSQL Hackers Message-ID: Subject: Re: Large expressions in indexes can't be stored (non-TOASTable) References: <1679756.1725476893@sss.pgh.pa.us> In-Reply-To: <1679756.1725476893@sss.pgh.pa.us> --------------0wXM9NCWf93kk9AdITXvnXFN Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 T24gOS80LzI0IDM6MDggUE0sIFRvbSBMYW5lIHdyb3RlOg0KPiBOYXRoYW4gQm9zc2FydCA8 bmF0aGFuZGJvc3NhcnRAZ21haWwuY29tPiB3cml0ZXM6DQo+PiBUaGFua3MgdG8gY29tbWl0 IDk2Y2RlYWUsIG9ubHkgYSBmZXcgY2F0YWxvZ3MgcmVtYWluIHRoYXQgYXJlIG1pc3Npbmcg VE9BU1QNCj4+IHRhYmxlczogcGdfYXR0cmlidXRlLCBwZ19jbGFzcywgcGdfaW5kZXgsIHBn X2xhcmdlb2JqZWN0LCBhbmQNCj4+IHBnX2xhcmdlb2JqZWN0X21ldGFkYXRhLiAgSSd2ZSBh dHRhY2hlZCBhIHNob3J0IHBhdGNoIHRvIGFkZCBvbmUgZm9yDQo+PiBwZ19pbmRleCwgd2hp Y2ggcmVzb2x2ZXMgdGhlIGlzc3VlIGNpdGVkIGhlcmUuICBUaGlzIHBhc3NlcyAiY2hlY2st d29ybGQiDQo+PiBhbmQgZGlkbid0IGZhaWwgZm9yIGEgZmV3IGFkIGhvYyB0ZXN0cyAoZS5n LiwgVkFDVVVNIEZVTEwgb24gcGdfaW5kZXgpLiAgSQ0KPj4gaGF2ZW4ndCBzcGVudCB0b28g bXVjaCB0aW1lIGludmVzdGlnYXRpbmcgcG9zc2libGUgY2lyY3VsYXJpdHkgaXNzdWVzLCBi dXQNCj4+IEknbGwgbm90ZSB0aGF0IG5vbmUgb2YgdGhlIHN5c3RlbSBpbmRleGVzIHByZXNl bnRseSB1c2UgdGhlIGluZGV4cHJzIGFuZA0KPj4gaW5kcHJlZCBjb2x1bW5zLg0KPiANCj4g WWVhaCwgdGhlIHBvc3NpYmlsaXR5IG9mIGNpcmN1bGFyaXR5IHNlZW1zIGxpa2UgdGhlIG1h aW4gaGF6YXJkLCBidXQNCj4gSSBhZ3JlZSBpdCdzIHVubGlrZWx5IHRoYXQgdGhlIGVudHJp ZXMgZm9yIHN5c3RlbSBpbmRleGVzIGNvdWxkIGV2ZXINCj4gbmVlZCBvdXQtb2YtbGluZSBz dG9yYWdlLiAgVGhlcmUgYXJlIG1hbnkgb3RoZXIgdGhpbmdzIHRoYXQgd291bGQgaGF2ZQ0K PiB0byBiZSBpbXByb3ZlZCBiZWZvcmUgYSBzeXN0ZW0gaW5kZXggY291bGQgdXNlIGluZGV4 cHJzIG9yIGluZHByZWQuDQoNCkFncmVlZCBvbiB0aGUgdW5saWtlbGluZXNzIG9mIHRoYXQs IGNlcnRhaW5seSBpbiB0aGUgc2hvcnQtdG8tbWlkIHRlcm0uIA0KVGhlIGltcGV0dXMgZHJp dmluZyB0aGlzIGlzIGRlYWxpbmcgd2l0aCBhIGRhdGEgdHlwZSB0aGF0IGNhbiBiZSBxdWl0 ZSANCmxhcmdlLCBhbmQgaXQncyB1bmxpa2VseSBzeXN0ZW0gY2F0YWxvZ3Mgd2lsbCBiZSBk ZWFsaW5nIHdpdGggYW55dGhpbmcgDQpvZiB0aGF0IG5hdHVyZSwgb3IgcmVxdWlyaW5nIHZl cnkgbG9uZyBleHByZXNzaW9ucyB0aGF0IGNvdWxkbid0IGJlIA0KZW5jYXBzdWxhdGVkIGlu IGEgZGlmZmVyZW50IHdheS4NCg0KSnVzdCB0byBiZSBmYWlyLCBpbiB0aGUgY2FzZSBJIHBy ZXNlbnRlZCB0aGVyZSdzIGFuIGFyZ3VtZW50IHRoYXQgd2hhdCANCkknbSB0cnlpbmcgdG8g ZG8gaXMgZmFpcmx5IGluZWZmaWNpZW50IGZvciBhbiBleHByZXNzaW9uLCBnaXZlbiBJJ20g DQpwYXNzaW5nIGFyb3VuZCBhbiBhZGRpdGlvbmFsIHNldmVyYWwgS0IgcGF5bG9hZCBpbnRv IHRoZSBxdWVyeS4gSG93ZXZlciwgDQp3ZSdkIGxpa2VseSBoYXZlIHRvIGRvIHRoYXQgYW55 d2F5IGZvciB0aGlzIHByb2JsZW0gc3BhY2UsIGFuZCB0aGUgDQpvdmVyYWxsIHBlcmZvcm1h bmNlIGhpdCBpcyBuZWdsaWdpYmxlIGNvbXBhcmVkIHRvIHRoZSBzZWFyY2ggcmVsZXZhbmN5 IA0KYm9vc3QuDQoNCkknbSB3b3JraW5nIG9uIGEgbXVjaCBtb3JlIHJvYnVzdCB0ZXN0LCBi dXQgdXNpbmcgYSBrbm93biAxME1NIDc2OC1kaW0gDQpkYXRhc2V0IGFuZCB0d28gQy1iYXNl ZCBxdWFudGl6YXRpb24gZnVuY3Rpb25zIChvbmUgdXNpbmcgdGhlIA0KZXhwcmVzc2lvbiks IEkgZ290IGEgMyUgcmVsZXZhbmN5IGJvb3N0IHdpdGggYSAyJSByZWR1Y3Rpb24gaW4gbGF0 ZW5jeSANCmFuZCB0aHJvdWdocHV0LiBPbiBzb21lIG90aGVyIGtub3duIGRhdGFzZXRzLCBJ IHdhcyBhYmxlIHRvIGltcHJvdmUgDQpyZWxldmFuY3kgNDAlIG9yIG1vcmUsIHRob3VnaCBn aXZlbiB0aGV5IHdlcmUgaW5pdGlhbGx5IHJldHVybmluZyB3aXRoIA0KMCUgcmVsZXZhbmN5 IGluIHNvbWUgY2FzZXMsIGl0J3Mgbm90IGZhaXIgdG8gY29tcGFyZSBwZXJmb3JtYW5jZSBu dW1iZXJzLg0KDQpUaGVyZSBhcmUgb3RoZXIgd2F5cyB0byBzb2x2ZSB0aGUgcHJvYmxlbSBh cyB3ZWxsLCBidXQgYWxsb3dpbmcgZm9yIHRoZSANCmxhcmdlciBleHByZXNzaW9uIGdpdmVz IHVzZXJzIG1vcmUgY2hvaWNlcyBpbiBob3cgdGhleSBjYW4gYXBwcm9hY2ggaXQuDQoNCkpv bmF0aGFuDQo= --------------0wXM9NCWf93kk9AdITXvnXFN-- --------------ewDPmK0Mo4Qao38l3MhiZQnk Content-Type: application/pgp-signature; name="OpenPGP_signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="OpenPGP_signature.asc" -----BEGIN PGP SIGNATURE----- wsF5BAABCAAjFiEE+oS2la8r95ogZD/x8QSccp8cZScFAmbYswIFAwAAAAAACgkQ8QSccp8cZSdi zw//US5AaxEwYCoe8ty9HQyw0pgJ6nTukVrgaixawJVEizFyieXrPGM7rcQNrJMeIsKtopNuNDMw TSeckLW468YkYbBDHAegaabn316dF3Xdbw8r5jdxlw2CkPWRPXxcTdPG9UG4luYfNQwtvYougH52 HcB/s5IRRZ+9EiNUFP/6DmP3FBZ+gErpV9lyv7I12b02qkjaUmKeKUOcfmSo4u2XAwRnmKdo7kyO uSipCrMmwKOPZ9GoEGnFHwpnv0doEomU5mDLYk17Foep98abQNywKKj+GeaCEfn3Czy0Rn3BMVpt Fj6lIWXiTm/BQap2KAUXxwiGDbSoVa2+tjaHUelxuijSYYop1b0tkAsk4/fJJpNfsVnRccdK4CYX 7a4mRZoQYJviSQBY60HDYlM6GcWBXs2C8JeQ5n57zJYnPCrKkhPmlimQLhktlUwIw55CLkCUQEB/ kMYqXTifVclsu3wvl7KkY/WZYJIS3ajtphvhQgP6D2OG5/a+EqfK9Wui7a6CFMDpM/5T5K/NgD1s bu8ZUu2XdkwtylXkpgCAOizerUsGheqr6OKZ+v7lU05AL0Fxbf/D9BPSj1XzxLofQ+fvqevPiSrp L+IH5ipSU3531vmG7oOLf6Z1QpPTLtsd06ZnzQ2HbMTxLpBhqcNGmNNJSeftv3H5pfasGgXsO27S ADM= =pZDz -----END PGP SIGNATURE----- --------------ewDPmK0Mo4Qao38l3MhiZQnk--