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 1slWVV-008MNd-4t for pgsql-hackers@arkaria.postgresql.org; Tue, 03 Sep 2024 16:35:54 +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 1slWVU-00Dxtk-3G for pgsql-hackers@arkaria.postgresql.org; Tue, 03 Sep 2024 16:35:52 +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 1slWVT-00Dxt6-Bi for pgsql-hackers@lists.postgresql.org; Tue, 03 Sep 2024 16:35:51 +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 1slWVQ-000Tjr-O7 for pgsql-hackers@lists.postgresql.org; Tue, 03 Sep 2024 16:35:50 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Content-Type:To:Cc:Subject:From:MIME-Version: Date:Message-ID:Sender:Reply-To:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=Ly8US4nplIsOl9944rUEwJd2/HtCudNXGLNdLr2abUI=; b=d5OYOmrAIrKDj6F7fFCgyxvyKz +745Uge2GK/OWHpPfYu7HpmgTmgpDzVLRTiIfpGWPGSyi7yOtrwuYTdq7qra9QD2uKXSuKPgekOrM AyQE75benPgEvnbK6OKHB8BqeDaa92e1a09NVriauqQAKUSGE7d6erWwwHQUjwWS4j5US0giZGknV jhX6NW42DnsvsK0uZEqq1yzDnv9a1zLjoHtNqvfUXFbOMRf+sax7ik6txFkP45wNewcVTd/wcuEFV c2QqwMSJ3RI8O6fCgOMqbdd91UWpqmEjzBDJl5YXZSEXKB7F8gys8yUTxZa7Cw34tc29g5B6Dhvgn sHoifTZw==; 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 1slWVM-001RrP-4g; Tue, 03 Sep 2024 16:35:47 +0000 Message-ID: Date: Tue, 3 Sep 2024 12:35:42 -0400 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Content-Language: en-US From: "Jonathan S. Katz" Subject: Large expressions in indexes can't be stored (non-TOASTable) 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 Cc: Nathan Bossart To: PostgreSQL Hackers Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------KBwav4YwHjiOJhaIr9n9LQ3s" 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) --------------KBwav4YwHjiOJhaIr9n9LQ3s Content-Type: multipart/mixed; boundary="------------tIQW25mJ7p5YZI8bSJXWaWkp"; protected-headers="v1" From: "Jonathan S. Katz" To: PostgreSQL Hackers Cc: Nathan Bossart Message-ID: Subject: Large expressions in indexes can't be stored (non-TOASTable) --------------tIQW25mJ7p5YZI8bSJXWaWkp Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 SGksDQoNCkkgcmFuIGludG8gYW4gaXNzdWUgKHByZXZpb3VzbHkgZGlzY3Vzc2VkWzFdOyBx dW90aW5nIEFuZHJlcyBvdXQgb2YgDQpjb250ZXh0IHRoYXQgbm90IGFkZHJlc3NpbmcgaXQg dGhlbiB3b3VsZCAiW2FdbGwgYnV0IGd1YXJhbnRlZSB0aGF0IA0Kd2UnbGwgaGF2ZSB0aGlz IGRpc2N1c3Npb24gYWdhaW4iWzJdKSB3aGVuIHRyeWluZyB0byBidWlsZCBhIHZlcnkgbGFy Z2UgDQpleHByZXNzaW9uIGluZGV4IHRoYXQgZGlkIG5vdCBmaXQgd2l0aGluIHRoZSBwYWdl IGJvdW5kYXJ5LiBUaGUgDQpyZWFsLXdvcmxkIHVzZSBjYXNlIHdhcyByZWxhdGVkIHRvIGEg dmVjdG9yIHNlYXJjaCB0ZWNobmlxdWUgd2hlcmUgSSANCndhbnRlZCB0byB1c2UgYmluYXJ5 IHF1YW50aXphdGlvbiBiYXNlZCBvbiB0aGUgcmVsYXRpb25zaGlwIGJldHdlZW4gYSANCmNv bnN0YW50IHZlY3RvciAodGhlIGF2ZXJhZ2UgYXQgYSBwb2ludC1pbi10aW1lIGFjcm9zcyB0 aGUgZW50aXJlIGRhdGEgDQpzZXQpIGFuZCB0aGUgdGFyZ2V0IHZlY3RvclszXVs0XS4gQW4g ZXhhbXBsZToNCg0KQ1JFQVRFIElOREVYIE9OIGVtYmVkZGluZ3MNCiAgIFVTSU5HIGhuc3co KHF1YW50aXphdGlvbl9mdW5jKGVtYmVkZGluZywgJFZFQ1RPUikpIGJpdF9oYW1taW5nX29w cyk7DQoNCkhvd2V2ZXIsIEkgcmFuIGludG8gdGhlIGlzc3VlIGluWzFdLCB3aGVyZSBwZ19p bmRleCB3YXMgaWRlbnRpZmllZCBhcyANCmNhdGFsb2cgdGhhdCBpcyBtaXNzaW5nIGEgdG9h c3QgdGFibGUsIGV2ZW4gdGhvdWdoIGBpbmRleHByc2AgaXMgbWFya2VkIA0KZm9yIGV4dGVu ZGVkIHN0b3JhZ2UuIFByb3ZpZGluZyBhIHZlcnkgc2ltcGxlIHJlcHJvZHVjZXIgaW4gcHNx bCBiZWxvdzoNCg0KLS0tLQ0KQ1JFQVRFIFRBQkxFIGRlZiAoaWQgaW50KTsNClNFTEVDVCBh cnJheV9hZ2cobikgYiBGUk9NIGdlbmVyYXRlX3NlcmllcygxLDEwXzAwMCkgbiBcZ3NldA0K Q1JFQVRFIE9SIFJFUExBQ0UgRlVOQ1RJT04gdmVjX3F1YW50aXplciAoYSBpbnQsIGIgaW50 W10pIFJFVFVSTlMgYm9vbCANCkFTICQkIFNFTEVDVCB0cnVlICQkIExBTkdVQUdFIFNRTCBJ TU1VVEFCTEU7DQpDUkVBVEUgSU5ERVggT04gZGVmICh2ZWNfcXVhbnRpemVyKGlkLCA6J2In KSk7DQoNCkVSUk9SOiAgcm93IGlzIHRvbyBiaWc6IHNpemUgMjk0NDgsIG1heGltdW0gc2l6 ZSA4MTYwDQotLS0NCg0KVGhpcyBjYW4gY29tZSB1cCB3aXRoIHZlY3RvciBzZWFyY2hlcyBh cyB2ZWN0b3JzIGNhbiBiZSBxdWl0ZSBsYXJnZSAtIA0KdGhlIGNhc2UgSSB3YXMgdGVzdGlu ZyBpbnZvbHZlZCBhIDE1MzYtZGltIGZsb2F0aW5nIHBvaW50IHZlY3RvciAofjZLQiksIA0K YW5kIHRoZSBub2RlIHBhcnNlIHRyZWUgcHVzaGVkIHBhc3QgdGhlIHBhZ2UgYm91bmRhcnkg YnkgYWJvdXQgMktCLg0KDQpPbmUgY291bGQgYXJndWUgdGhhdCBwZ3ZlY3RvciBvciBhbiBl eHRlbnNpb24gY2FuIGJ1aWxkIGluIGNhcGFiaWxpdGllcyANCnRvIGhhbmRsZSBxdWFudGl6 YXRpb24gaW50ZXJuYWxseSB3aXRob3V0IHJlcXVpcmluZyB0aGUgdXNlciB0byBwcm92aWRl IA0KYSBzb3VyY2UgdmVjdG9yIChwZ3ZlY3RvcnNjYWxlIGRvZXMgdGhpcykuIEhvd2V2ZXIs IHRoaXMgYWxzbyBsaW1pdHMgDQpmbGV4aWJpbGl0eSB0byB1c2VycywgYXMgdGhleSBtYXkg d2FudCB0byBicmluZyB0aGVpciBvd24gcXVhbnRpemF0aW9uIA0KZnVuY3Rpb25zIHRvIHZl Y3RvciBzZWFyY2hlcywgZS5nLiwgYXMgZGlmZmVyZW50IHF1YW50aXphdGlvbiB0ZWNobmlx dWVzIA0KZW1lcmdlLCBvciBpZiBhIHBhcnRpY3VsYXIgdGVjaG5pcXVlIGlzIG1vcmUgc3Vp dGFibGUgZm9yIGEgcGVyc29uJ3MgDQpkYXRhc2V0Lg0KDQpUaGFua3MsDQoNCkpvbmF0aGFu DQoNClsxXSANCmh0dHBzOi8vd3d3LnBvc3RncmVzcWwub3JnL21lc3NhZ2UtaWQvZmxhdC84 NGRkZmYwNC1mMTIyLTc4NGItYjZjNS0zNTM2ODA0NDk1ZjglNDBqb2Vjb253YXkuY29tDQpb Ml0gDQpodHRwczovL3d3dy5wb3N0Z3Jlc3FsLm9yZy9tZXNzYWdlLWlkLzIwMTgwNzIwMDAw MzU2LjV6a2h2ZnBzcXN3bmd5b2IlNDBhbGFwMy5hbmFyYXplbC5kZQ0KWzNdIGh0dHBzOi8v Z2l0aHViLmNvbS9wZ3ZlY3Rvci9wZ3ZlY3Rvcg0KWzRdIGh0dHBzOi8vamthdHowNS5jb20v cG9zdC9wb3N0Z3Jlcy9wZ3ZlY3Rvci1zY2FsYXItYmluYXJ5LXF1YW50aXphdGlvbi8NCg== --------------tIQW25mJ7p5YZI8bSJXWaWkp-- --------------KBwav4YwHjiOJhaIr9n9LQ3s 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/x8QSccp8cZScFAmbXOt8FAwAAAAAACgkQ8QSccp8cZSek nQ/+MCj/+oFxQYPfjGUdRsBi7a5u7yRpvbzzbIGOQLdt8TtJMax+nierRMNGO7L/CISaE1KBzRvC ectxrpUZtuvwVy361pdf6sndHoTKghBON4NjhJeJ+O2lxQHjENDGOHVAbzq4y7LO/TAo3C4/etAQ /lWbGDVWywtLH26wbvkuNsK8/vsqbnd4+iQ9i1RJbyWuYK1+qzPsmwz7jc3fiKSSxiGmFbEChmgH gKmwriqQ8MHOWo7sz2mck9NANgnMemWv0rnJEKn8+/vidGIZRj+3IM8AJtngv0amXT3T3NVljCGN 02MI1EDvIdtCSVs+TjAKb008duClL7EwnFkTus1qmN/m1UKLcnw15dWKer+pBPCe7DGCpA6DsgMa FNPJfMNNIvaMCnax20Z8sMB+F1BHzj+Die3A6ch1T7MIDLNpuAW4o1uo2eIC/Rb1iDUauWTl9ZpS DYRWNGE4lHmwwXuoXOvdikJ297LWB39U/ni4dqvKKp0Zfmxn4q3mNrYuBUG4gr/Fc+6wH+EJL6s8 Hk1H/XRWZT/gHzvxacPr7SHsoXPFZiaDFWD9QYeCTFoYGDbXpNGRAMZoXKXG/JoYswtNErM6crdS d6NLZuMGEO0U+dfJH7pfnKdeRAYLUZNgzFSBZ0DxxVVUXmIq2PR2epYxWr2UogmC+K5Le3Ts7w9Q 7Uk= =4Olo -----END PGP SIGNATURE----- --------------KBwav4YwHjiOJhaIr9n9LQ3s--