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 1uL6Cj-000pn7-Mq for pgsql-hackers@arkaria.postgresql.org; Fri, 30 May 2025 20:19:49 +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 1uL6Ci-005oBB-Ca for pgsql-hackers@arkaria.postgresql.org; Fri, 30 May 2025 20:19:48 +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 1uL6Ci-005oB0-2Q for pgsql-hackers@lists.postgresql.org; Fri, 30 May 2025 20:19:48 +0000 Received: from mail-il1-x136.google.com ([2607:f8b0:4864:20::136]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uL6Cf-000wJq-1e for pgsql-hackers@lists.postgresql.org; Fri, 30 May 2025 20:19:47 +0000 Received: by mail-il1-x136.google.com with SMTP id e9e14a558f8ab-3d8020ba858so21883165ab.0 for ; Fri, 30 May 2025 13:19:45 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1748636384; x=1749241184; darn=lists.postgresql.org; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:from:to:cc:subject:date:message-id:reply-to; bh=SiGYYuxRb4Ea/X7AZM2Uv9yrbUGtCd0glMDlXvJQQZ4=; b=BRLWa87b4tiHlV18I72B2B9v97w8M1Vkbb6P0+ggLvnyN1I1Lo3+gADHk6OC4O25HG eUU3a44E00FLrHJtS7/hqg+JihPG5ApU0knzf/y6FK1kOzpuIymQut963TiHZN0XQPNf c20ghp4Yuy8ywz5jwMsgUyhKpVAnTrKCgOUg1G8yGLOnBqQFUMJV2WRbqZf688P4B7Aw B41RJaWiKgrv5mvVsL8Smo3ChjhDN0xK+6aKPf2HQ1IajjdTM8pJvX4sdjfvRolSMKjI Rj1BT8H8avJDEn0NG9WlhiUjqcdMiyo1rmz9GxnH2zI0h0RF4fFt5ooKW27TBWlL/G+q 12Lg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1748636384; x=1749241184; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=SiGYYuxRb4Ea/X7AZM2Uv9yrbUGtCd0glMDlXvJQQZ4=; b=nscF7N/82NHSfoQSIxQlyEvgRnCXxFPL8L4Jd9HGS8x79P8nBT8AGBUX5hybS6+noj xQcukILLrwWZ7sTVNB67cEO0qlAaurJi+OfhdDniZtHkbm0MLfR11XeA76BSElZcLymj tceGQZ4a3hvj69eHtdeOnFbSzjxp4at7wfAktqp56NWf57ESDnJyr6iI+GCHogkEaIgP fJWswWHrkknnacADLfrU53nVuglYRTOtbZIaszMBYSUf/LK8yFefIxba+dn0PYz+uIF+ orWbAuq1gC3+o1L3i3Q59brLAjyOQFsm5eQiaHi01W27wzmzYBN4P76ihkpkLXaKW5iw vWaw== X-Forwarded-Encrypted: i=1; AJvYcCX9OtxW2PHxpPpL8yQo6RTIHsL5Jjy7LYuQ5MvKSiXbldv+evMZnc1+YXQyyM5Lylacs8sib/GGDRzLjpFQ@lists.postgresql.org X-Gm-Message-State: AOJu0YyhzwzIH+0Hf6ItYAirxqMNpBzj+RO2VfSZhl6A7R0m5ayPSJpI j3A6+B2UMSW1EkIm2IrQz7pFn2YcjGPRYOJs8ZVR4GoDPKXU//u2Jy9Y X-Gm-Gg: ASbGncsiXX5ZnwzSKPyotPxL4wB505TVzKjkkkQfpqoqfPKdPoGBfKunEYviQkjXfVH X3xIy2i5WD68g+GCNaxf6FgxvXcbQR/jXLmDxfW1+ZB4W5aHSyBwCI02Cubivr21r7ZsQ7fOftN iCYEhDVGUkj9fhNCnUoZn0Q+GpgkX1IfsedrXpWvYLH/o46XE6S++1LgsClzNubKtYCHhut/ywW Hg41ols7EElPI8JTlb2ipBQvgwJ0CP7XRagDVjlSaQsOOGdwUH1uW+k5vZfyOZn/3/mk7ZlcDgo ucgbjZ4NASNyEDrS+rUqGyjfwNthc2faC5b5VwQUPjBk+RKa5gUpdF8Xmi7juDMQr1KwUWaWcWX QyKkJIFqW5vF4igVqjuXnD0zyywUDaEYfaeC2xQSqGg== X-Google-Smtp-Source: AGHT+IFMTNhepwh94ik/jttwVu/ix4pakpJ0X32sE+shiRgKFYXIdzT71lCUmLdLCoRVRuTZWdEP1g== X-Received: by 2002:a05:6e02:1a6c:b0:3dc:8797:a8bf with SMTP id e9e14a558f8ab-3dd99af14aamr57487325ab.0.1748636384045; Fri, 30 May 2025 13:19:44 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id e9e14a558f8ab-3dd94ac99dcsm8135045ab.70.2025.05.30.13.19.43 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 30 May 2025 13:19:43 -0700 (PDT) Date: Fri, 30 May 2025 15:19:41 -0500 From: Nathan Bossart To: Michael Paquier 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: <910625.1745878759@sss.pgh.pa.us> <1055453.1745949714@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, May 28, 2025 at 11:43:52AM +0900, Michael Paquier wrote: > Thanks for the refreshed versions. Looks sensible to me overall. Committed. Thanks for reviewing. -- nathan