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 1t1ZcU-00Gt2D-KB for pgsql-hackers@arkaria.postgresql.org; Thu, 17 Oct 2024 23:09:26 +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 1t1ZcR-00BaXZ-Ic for pgsql-hackers@arkaria.postgresql.org; Thu, 17 Oct 2024 23:09:23 +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 1t1ZcR-00BaXR-8r for pgsql-hackers@lists.postgresql.org; Thu, 17 Oct 2024 23:09:23 +0000 Received: from fhigh-a3-smtp.messagingengine.com ([103.168.172.154]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1t1ZcL-001cGN-4d for pgsql-hackers@lists.postgresql.org; Thu, 17 Oct 2024 23:09:22 +0000 Received: from phl-compute-08.internal (phl-compute-08.phl.internal [10.202.2.48]) by mailfhigh.phl.internal (Postfix) with ESMTP id 9051911401AA; Thu, 17 Oct 2024 19:09:15 -0400 (EDT) Received: from phl-mailfrontend-01 ([10.202.2.162]) by phl-compute-08.internal (MEProxy); Thu, 17 Oct 2024 19:09:15 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:cc:content-type:content-type:date:date:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:subject :subject:to:to; s=fm2; t=1729206555; x=1729292955; bh=O+BBFHk7k4 PgMSIit1kaHXT2K5i0DggtahDKjNvsORg=; b=a6eDGdPrpnHxvDzlJz/Dtw49gE yCBvdtx6IIQ7UsR8Pdb5eTiWvTWTssr4CjT+oRqmdve7k8CmNLjDhnBgiYPa4+AD fmdk2lp08Q+G/QMlLOkyiuCCdubzcejkf8GoCrEjbHKRUf2RnWIrGYe5WMbtEX1P UsaAJm92g2gnBJfeUDgmYpwSC0ivTOKZ+AM0Heh18hhe4ScE8GDhZym7DzJGYU3E A+SFtNpHXhMLU8yk90qo9lvL257uhx6fdFGHTCoh5mLpguAmOWuO0QfrkXBG03dt aPwoZWMhiS9Th8AOYiJjjkgxb7g6xFXsJUo6g6SivTgOUNBmsF01oJHuUSZQ== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:content-type:date:date :feedback-id:feedback-id:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:subject:subject:to :to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s= fm2; t=1729206555; x=1729292955; bh=O+BBFHk7k4PgMSIit1kaHXT2K5i0 DggtahDKjNvsORg=; b=hDjkwNOaCPqi+jZSwumx+ro6vSetwKMRuk7AZ3k3gR8M SPJ3c5nN9yfuKBDCDk40XK6EvzCVmFydqgm+hmusWCfX2y9n5NDsyMV+UZbMW2Ga sXvTwz4QC+NaB7EgA3jwouIujfPxYj3Gym7UHjFl6vPwwSu9lfJQvhn0a04HSHly B1pTJhNpRW9cyJHM25n3U5dpnjJuRgV7PHNu8bPZwjc++GdmuK4J+j6Fv9gCEhfJ +pY9oJ5MegwONzOM1c+blol7SYkJbgv3P7HgqwbCpmCCck0KV20G6mD0Icdyu5G2 I06sR1XS4/g59gZkGRhzaiRx1Sg0zi8PA1os2PZGQg== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeftddrvdehvddgudelucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdggtfgfnhhsuhgsshgtrhhisggvpdfu rfetoffkrfgpnffqhgenuceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnh htshculddquddttddmnegfrhhlucfvnfffucdljedtmdenucfjughrpeffhffvvefukfhf gggtuggjsehgtderredttddvnecuhfhrohhmpefoihgthhgrvghlucfrrghquhhivghruc eomhhitghhrggvlhesphgrqhhuihgvrhdrgiihiieqnecuggftrfgrthhtvghrnhepteel ieefudffhffhtdetleeggeegfffhkeeuveetiefgudduvedutefggeeivdejnecuvehluh hsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomhepmhhitghhrggvlhes phgrqhhuihgvrhdrgiihiidpnhgspghrtghpthhtohephedpmhhouggvpehsmhhtphhouh htpdhrtghpthhtohepnhgrthhhrghnuggsohhsshgrrhhtsehgmhgrihhlrdgtohhmpdhr tghpthhtohepvgigtghluhhsihhonhesghhmrghilhdrtghomhdprhgtphhtthhopehtgh hlsehsshhsrdhpghhhrdhprgdruhhspdhrtghpthhtohepjhhkrghtiiesphhoshhtghhr vghsqhhlrdhorhhgpdhrtghpthhtohepphhgshhqlhdqhhgrtghkvghrsheslhhishhtsh drphhoshhtghhrvghsqhhlrdhorhhg X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Thu, 17 Oct 2024 19:09:13 -0400 (EDT) Date: Fri, 18 Oct 2024 08:08:55 +0900 From: Michael Paquier To: Nathan Bossart Cc: Alexander Lakhin , Tom Lane , "Jonathan S. Katz" , PostgreSQL Hackers Subject: Re: Large expressions in indexes can't be stored (non-TOASTable) Message-ID: References: MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="HdueuLV6uLwBwgHE" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --HdueuLV6uLwBwgHE Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Wed, Oct 16, 2024 at 10:54:45AM -0500, Nathan Bossart wrote: > Here is a new version of the patch set with this #ifdef added. I plan to > give each of the code paths adjusted by 0001 a closer look, but otherwise > I'm hoping to commit these soon. 0002 and 0003 look sane enough to me as shaped. I'd need to spend a few more hours on 0001 if I were to do a second round on it, but you don't really need a second opinion, do you? :D -- Michael --HdueuLV6uLwBwgHE Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmcRmQcACgkQnvQgOdby QH1S/hAAnx5jE4lthpVhqz+FHZ+pHLnvU2kkyW40JsT6+gevYii+VXzSFQ2pNlUO iRj4H3w04N6ZiYpOB0Z9pcRuqisdjPySnpJ7y3kVRtqAOzeauO1W+asQcrF6UMjW RNgq9gOG1Ei6sZuuA7odiuWc+2AcxlsLQrJ/n8GGFPaSK21S0TkNksF9genud+4O 2tInJ21laUnRj+8RXkFbb9UpET4GCAZ2W6mc3wCU3xy8/f0c0UY310SPrFawkU1u qcahzDaVBUA4mHs0wU+JXS008uiKZ6FVB4lIoi7w4sTCRiBVHw+qDXRj6o/ACKhF BrV0xLWIPhrHNGxeC88+1e/m6tOshv/Iw6rXrorxR2dI3pDnkmTcHx18GakEHnFx d45WpC/VmVWZYkRZb3gBRrD665ILjbfgGlifJNcqewpUcRRML6U0V5mq+i+3KpY1 Ehs6AMzV0VckdJzkOR6AM9QJyJw2jXVsUBxnn29tDAHtIMiQB20z4U9osic04e4V kU8ce7uHM76Zes2tznIgy6yc/slPLK5GKzC7jDRf75yFxRCUs+lSI89i9Yj8zGQy gLKgT2A/WKmIj+YauTTDoek6sK7vTF6GMLNumRauzKB82Bt8KRz55mcAlbWowDOR gZ43iDWOa6RYRoSgmU72fKSfFLFecimuw8pYh4DbB3LZOGKIlFw= =T/fQ -----END PGP SIGNATURE----- --HdueuLV6uLwBwgHE--