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 1uCobn-002eLr-JE for pgsql-hackers@arkaria.postgresql.org; Wed, 07 May 2025 23:55:28 +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 1uCobm-00HIvw-FX for pgsql-hackers@arkaria.postgresql.org; Wed, 07 May 2025 23:55:26 +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 1uCobl-00HIvN-CR for pgsql-hackers@lists.postgresql.org; Wed, 07 May 2025 23:55:26 +0000 Received: from fhigh-a2-smtp.messagingengine.com ([103.168.172.153]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1uCobi-000iYr-0B for pgsql-hackers@lists.postgresql.org; Wed, 07 May 2025 23:55:25 +0000 Received: from phl-compute-02.internal (phl-compute-02.phl.internal [10.202.2.42]) by mailfhigh.phl.internal (Postfix) with ESMTP id C0CCC114012B; Wed, 7 May 2025 19:55:19 -0400 (EDT) Received: from phl-mailfrontend-01 ([10.202.2.162]) by phl-compute-02.internal (MEProxy); Wed, 07 May 2025 19:55:19 -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=fm3; t=1746662119; x=1746748519; bh=5l6Y0wwLJt njzenxSbP8Wg8aDKy3pMp5KJpFY+YmHjs=; b=A93d+r/6EJmwjkdKQjeebBiC8v UJflhrWaJCME+t2W5QRmSh3e6xuCkq5DNXNfnCZzrFK6lwJniOhfot+x8ZHMt9Lv S7x5TRnwFZEpJye9M5wHQ00zYR9NvuWNQtkZhoZkTCtbgYpNMikZE8IEaUcWPwNu sQmTM3cV2Pt1LlQnWMTW2lsFGRMkoIGa8uMimyJyQeJLXShiYjhMQX6cFt4lvvmF 40R0k8k3k/N3nOpsGT88+YjR6dD0egxfPSmw176xb/4r6WkCEnmAPz1lcicjBr4X 4CXQRw6qTlE+gZq+hDE2sefouMbfmGYVtoJ70qE2Q9dMqOGJvRqHAXQCx7Sg== 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-sender:x-me-sender:x-sasl-enc; s=fm3; t= 1746662119; x=1746748519; bh=5l6Y0wwLJtnjzenxSbP8Wg8aDKy3pMp5KJp FY+YmHjs=; b=lPVz5pNYVFYVdggD2vGEtK11L7YqA5BNvefztKUr8iJRqEEMDfJ +kc3WK+UU3jqsR52ZfhUgCx/Nu8EhWjCSeScGEeqzB91zbNat0Fwn9qqwdbU8Wo2 vlJ28Vga++feGRPyy8WcISrDgwmroFDkrx3mCO7ITy0SBNHHKZg8rBqgpfbxuj4l KfCcMpncQ/AcVYCuy6kYqcKSHeRUv8Pf4/dAULsTd2o12G/m4F8swxUo8ewd0rAs us20VgLvLgzMA3+yjmeCv/tUI/3rf5AMMjEJ8XikU8nwZ2+0i60Q6DfUm69YfGh7 JQn00v7I3BzUBlBk4+0YYN1ZPvk3QbDrAqQ== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefvddrtddtgddvkeekvdefucetufdoteggodetrf dotffvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdggtfgfnhhsuhgsshgtrhhisggv pdfurfetoffkrfgpnffqhgenuceurghilhhouhhtmecufedttdenucesvcftvggtihhpih gvnhhtshculddquddttddmnegfrhhlucfvnfffucdljedtmdenucfjughrpeffhffvvefu kfhfgggtuggjsehgtderredttddvnecuhfhrohhmpefoihgthhgrvghlucfrrghquhhivg hruceomhhitghhrggvlhesphgrqhhuihgvrhdrgiihiieqnecuggftrfgrthhtvghrnhep teelieefudffhffhtdetleeggeegfffhkeeuveetiefgudduvedutefggeeivdejnecuve hluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomhepmhhitghhrggv lhesphgrqhhuihgvrhdrgiihiidpnhgspghrtghpthhtohepkedpmhhouggvpehsmhhtph houhhtpdhrtghpthhtohepnhgrthhhrghnuggsohhsshgrrhhtsehgmhgrihhlrdgtohhm pdhrtghpthhtohepthhglhesshhsshdrphhghhdrphgrrdhushdprhgtphhtthhopehnih hshhgrrdhmohhonhgugeduvdesghhmrghilhdrtghomhdprhgtphhtthhopegvuhhlvghr segvuhhlvghrthhordgtohhmpdhrtghpthhtoheprghmihhtrdhkrghpihhlrgduieesgh hmrghilhdrtghomhdprhgtphhtthhopegvgigtlhhushhiohhnsehgmhgrihhlrdgtohhm pdhrtghpthhtohepjhhkrghtiiesphhoshhtghhrvghsqhhlrdhorhhgpdhrtghpthhtoh epphhgshhqlhdqhhgrtghkvghrsheslhhishhtshdrphhoshhtghhrvghsqhhlrdhorhhg X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed, 7 May 2025 19:55:16 -0400 (EDT) Date: Thu, 8 May 2025 08:55:08 +0900 From: Michael Paquier To: Nathan Bossart Cc: Tom Lane , Nisha Moond , Euler Taveira , Amit Kapila , Alexander Lakhin , "Jonathan S. Katz" , PostgreSQL Hackers Subject: Re: Large expressions in indexes can't be stored (non-TOASTable) Message-ID: References: <905635.1745876108@sss.pgh.pa.us> <910625.1745878759@sss.pgh.pa.us> <1055453.1745949714@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="koQ8kIdWJXmHh+J8" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --koQ8kIdWJXmHh+J8 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Wed, May 07, 2025 at 02:55:49PM -0500, Nathan Bossart wrote: > Committed with that change. That takes care of a good chunk of these TOAST > snapshot problems. I think there are about 4 others left, unless something > has changed since I last checked. I hope to look into those again soon. Thanks, for both things. -- Michael --koQ8kIdWJXmHh+J8 Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmgb8twACgkQnvQgOdby QH15og//XcqlcRx49i9l0efLdy+2cPBcLwIjiwjwl11oxDpLu+3rJWfrEWUi7dnH Xc0heH+cst3ZecshNPt4I6g0TXosJqUlcHUNRFcMeJ1ItEAHG8FIf+BdWFhMbvpr FHr1UkI3EBKhNE45kivMmveDDOXk/GlqaJoQVrwsVe+PspbYUNgd87yVrbY+O6iF SPofIuTEy4e6qvrL7EnVv/VRTtcONIx3wIDFxYZkQnvevJieqIkTbdhh9o64HUPt OHJ/yJNe3+DNGxzCOvBRvAeZKzxtbJt/ZvAhkIgFsxLeIMfbbpik11Tnbb4mZ82R 0lubNpjdRAsZXHscEaTp7BGWKxGGxJDNXVHPmOcwFcWEZyay2zl+lIEpv6n7QrRW HgZqijsE0xVhdnraw/Bu4CeU+Ez0Yf/XPpSd5Ud/2EhxEOJ6i5JCMOCyW6HTogZJ Nk9g0HlEUhJhIXFSa1JvZWvCHxVHyfwv1IsmIyZG4gweZUdpOXqUWPrrTU/euaAI eo2sfP8V57BvOlI3TGVsTGk54rcZ2C/9SDtk0DwSBTerSzoqARDrWUUTX4oChnFf PN4KT1R3Uov8jRvdPkbK/64h2v/G45sY/ZPLVKNnfczTQZhyGrSYH13/6VFzK3/X Y71eUzU/74xOf3Ke4LS7S8IwIickHvKLpVDPDyMbcycixA9Obtk= =OKMJ -----END PGP SIGNATURE----- --koQ8kIdWJXmHh+J8--