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 1uCLMj-00DsUl-94 for pgsql-hackers@arkaria.postgresql.org; Tue, 06 May 2025 16:41:57 +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 1uCLMi-008i7Q-9n for pgsql-hackers@arkaria.postgresql.org; Tue, 06 May 2025 16:41:56 +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 1uCLMi-008i7I-0b for pgsql-hackers@lists.postgresql.org; Tue, 06 May 2025 16:41:56 +0000 Received: from mail-io1-xd29.google.com ([2607:f8b0:4864:20::d29]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uCLMf-000Tbp-14 for pgsql-hackers@lists.postgresql.org; Tue, 06 May 2025 16:41:55 +0000 Received: by mail-io1-xd29.google.com with SMTP id ca18e2360f4ac-85dac9728cdso162271339f.0 for ; Tue, 06 May 2025 09:41:53 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1746549711; x=1747154511; 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=YtLELFiYCk+USASL0x8Jk7N28/KrQWaDMe1YcGe2zo0=; b=TgmvzgX3XNWnfHmiGLXUu1wQO1kJFMDoA9DDo894/OZ03gKa+M0Irp+h4CjNDTTvzx Pp7oBvp0wAfIEuvc/RFu3k+vygLSLmRgZtwdPrOJWc7MRm2FuQDtf4+MYIZUsUn8Pfqk vxZ/GyGGGe52Pqr7LB+5wYXa/NMkZ/AWixtSybkwa5kBWFJaZviFkxh3XxvmirgzZBeP SQqjEYmxQSjbBaxBAFtajkTC0Na2aCP6g9N619Jnq/UtovlBkoUXKeGKFQIFi7528nsx bETKcVz9bv3woY3X4i2UtNEGeQEEAYnJNrI2hvSGRm3ZCuXNQkMIvwTyTj7LlMBLbqHz YITA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1746549711; x=1747154511; 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=YtLELFiYCk+USASL0x8Jk7N28/KrQWaDMe1YcGe2zo0=; b=wKX5IrRU8ICnrxVsaDJCwBIxIMEu5XTWiG71+KtUN46ZgLSlQRCwxnzQIcU4bB2BQ5 chJcJS1nisUnL86YRUOszGWBrGktFRW15/5uTNlvFYppv+zw+8J9It0HUaLOvfs22S1t 8Wn/4oC3/lqWk4CWLOD7diP3TT2+T+VAa6vQ2yigSA5setWneGV+0pdduFzBjazRFaNr IJGCgKhsdKSmrEqkE0XxoPVlylS4WinpZRarQgSN+o8oTGe/+WsjLhgA7tW8vT1T6C58 0XwcjtFMXW8aRQ80E3nuBBHGcy0yrMN/vvy+33XK0vPYUR5j6m3WJTJtCqj/bfihvJEX +L4w== X-Forwarded-Encrypted: i=1; AJvYcCWf9/Gupqr1ViiBCMpAfeJUIwmfGtqVX5kvKubs26f17GUDdtMaE1+Pl2U/6WGTZ5cfK3cnB5tN/SHGFNB3@lists.postgresql.org X-Gm-Message-State: AOJu0YyRrkmHsLgX8wHDpkjsIoL3EiQ2F1dLKGX0W7GeCXdPGAf89oIi i9RL7pjw3Dm99yyGKX5qVzYTMeS6xYJ25zmjt4ln0ezC4xEn5XKV X-Gm-Gg: ASbGncvL+lxJQK2fIsTXf8fZoE/5Csm0p37vAQYD+DDDaehRcxMQPa0ZxKB2a4aW9xl XLxZRAO6xksZCLLasdqz/L2sfjQAhZsq7twnveITtWa2sX0jP7Ch0yFfu4Pmms5B7yhkgI0dZQm ssg0VQouIyCF+BUGG9mk5metuhrEGDvbdh3Voj/EFpopnGeRWc6rKWY79XxCWmljqg/+3qh5eGQ LCkeClpcJLEvUnqFfx2VnKAC0D/psG84twoTcqzLDVuYdlV2AF803XfOt7yW3ZEoQGYedSWENm+ fiSbxlbo/eVChsImrEh5YPQK/8vt3NvgvWnkMf3C04DhenWbDmRbrT+sXKQoWc2lDV+mNm6Aho8 9+rBbLEuuseXuZDoVzOlmjuiA27HYLrM= X-Google-Smtp-Source: AGHT+IGKchSgkaMEuNdnOlP6jInQ3D4h4epTpcZ2yyLIB1Cp5f6vYNhhbRb721Cj023eDLIsTlljng== X-Received: by 2002:a05:6602:15d0:b0:85b:3f1a:30aa with SMTP id ca18e2360f4ac-86747370088mr22853039f.9.1746549711256; Tue, 06 May 2025 09:41:51 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id 8926c6da1cb9f-4f88aa8dd1esm2300429173.113.2025.05.06.09.41.50 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 06 May 2025 09:41:50 -0700 (PDT) Date: Tue, 6 May 2025 11:41:49 -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: <1503201.1745444021@sss.pgh.pa.us> <905635.1745876108@sss.pgh.pa.us> <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, Apr 30, 2025 at 09:57:46AM +0900, Michael Paquier wrote: > On Tue, Apr 29, 2025 at 02:01:54PM -0400, Tom Lane wrote: >> I'm inclined to argue that it's a bug fix and therefore still in-scope >> for v18. The fact that we can't back-patch such a change is all the >> more reason to not let it slide another year. > > Not on the RMT. I have looked at the patch, and I would agree with > doing that now in v18 rather than wait for v19 to open up. > >> But probably the RMT should make the call. > > Yes. I brought this up with the RMT, and everyone seemed okay with committing it for v18. > This has been mentioned upthread, but I am questioning the wisdom of > putting the restriction based on MAX_RONAME_LEN only in > pg_replication_origin_create(), while replorigin_create() is the one > that actually matters. While it is true that these restrictions are > enforced for the current callers in core, it could also be called by > stuff outside of core. It seems important to me to let these > potential callers know about the restriction in place. I can move it back to replorigin_create(). I don't have a strong opinion here. -- nathan