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 1u7htq-004Wfj-OW for pgsql-hackers@arkaria.postgresql.org; Wed, 23 Apr 2025 21:44:59 +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 1u7hto-00Adqh-Ad for pgsql-hackers@arkaria.postgresql.org; Wed, 23 Apr 2025 21:44:57 +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 1u7htn-00AdqZ-WA for pgsql-hackers@lists.postgresql.org; Wed, 23 Apr 2025 21:44:56 +0000 Received: from mail-qk1-x72d.google.com ([2607:f8b0:4864:20::72d]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1u7htm-001bNW-0t for pgsql-hackers@lists.postgresql.org; Wed, 23 Apr 2025 21:44:55 +0000 Received: by mail-qk1-x72d.google.com with SMTP id af79cd13be357-7c55b53a459so35739285a.3 for ; Wed, 23 Apr 2025 14:44:54 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1745444694; x=1746049494; 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=k2fwpZiyPNyO2Tk6S2SmVsp2CbwjRsgbiAOw+nEddJE=; b=VwzU3BRSzMRoOwSfMlVItRc1jt5SPFJx09w4NSBguHoP4jBF0frLrMbGJ2iiG4og3j aubMQMZlHNygLOkIIFp6ZfQbXxf1IY1ulB0o6rdV6udlynt+gby2pDGfK0L00LDOp++9 R+Rtv6KIRF5+SM61ZRrTu28FEaM+LQmsI9W6KUfJNK4RmZjf87yWNoJUsxJ+OzffrY3f ZmwNEimVEzfUiCO5CSILBeZk8yLVREt4BVC1Sc41VxpGiTAWdGE7C+pux1J1UQEC022x +QBSBTcnCTPWWe64TpWGBBzw/TZ94khHrtEx3HDSkcD2U6fIMUH3z4KCJyB830+uRlx6 BC9Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1745444694; x=1746049494; 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=k2fwpZiyPNyO2Tk6S2SmVsp2CbwjRsgbiAOw+nEddJE=; b=QM8gOcVXQghiv4KylMnXEpBM8esnKzC75sCeTzLB3B6n9JulQp5Ojqxw+XDoGelbzr ZDP6iV+heBoba+ED0l0Lz2JLk5OzKdBJkY2jVwUzYqj771RrZIDqB8BzI1Juf/yFCRJA Bnq3kpfCKHvXnisngscS8kRAO/fwEFg5s2B7UZX5hUQpz6sFKw6vhWaM2IE1aOLbxM9P kaEiVQ4N8enR9dctYLaWMlFKYf/VxAfhMJ7s9gJ0hIGrhJtYovltVpfthO+nADQEbTid mK2rRDtvOo+RAkU2bqIEjzAO5c1ndY486+syftFyY2rKWFY3hpCyhaqQtxy/Mjy+4ZpI nS6g== X-Forwarded-Encrypted: i=1; AJvYcCVEcZWH0kbSkdmmvtUnDr65rqADdpoPvaK2/4D9zssjRZB0VatPLGHqPLnTvE9NQjwrO5uRv670dUY6L9C4@lists.postgresql.org X-Gm-Message-State: AOJu0YzgfdouDSilB8wQY41IAyT8dNaOTJsW5KHd4tCFoc7hoNQjlZZx iPHvAsGXP2diKwmR/BguYzxBxOex7QfBa1aeWFzQSGrYtwGxZ9sc X-Gm-Gg: ASbGncvB+Ze4ANhNdiYIUaqGFl1qYhEWxIpMN52B/4wSxd5oGoxWCmPt0kALEUWiK6N Uw8wDAXeYAnCb8T6gd+9Vsq0/25nGijdA+00RA5lTlMqd27NMi/zVp0+g5wyEhkA7vKYIdHoSvd B9foZB2ljlX5/Xc84nrrR6W2Kn+sNjksN70VQbjqDWz2snuCyFJyNfBwShB81P8RGtAUC1CcQsd CRwo8yhrYesoMhoxttEC+2oebC9eH9rD36E7MPQ8yqac0aON/GoJiXYJHIvqbCLvsPy87nPTThb FIzAES4UoOX/qGx2Ix+1ekQeLpV5QGwnaHweIE1EBhoyljXS5/62I9gdF0Mo8rJcDql58vPY+uB D77uUJVNKiYyxE8GNHfAFmHv3InvkMzc= X-Google-Smtp-Source: AGHT+IHai07ttRwxIunD36mlz3ebdUt6vexXHlPd8XLk5A0S5EjCPEhbVEEywajQ1wtFz2hhdFEMgg== X-Received: by 2002:a05:620a:440a:b0:7c5:4c49:76a5 with SMTP id af79cd13be357-7c956e7bea3mr61581185a.12.1745444693891; Wed, 23 Apr 2025 14:44:53 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id af79cd13be357-7c925a90c3fsm731260585a.46.2025.04.23.14.44.52 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 23 Apr 2025 14:44:53 -0700 (PDT) Date: Wed, 23 Apr 2025 16:44:51 -0500 From: Nathan Bossart To: Tom Lane Cc: Nisha Moond , Euler Taveira , Michael Paquier , Amit Kapila , Alexander Lakhin , "Jonathan S. Katz" , PostgreSQL Hackers Subject: Re: Large expressions in indexes can't be stored (non-TOASTable) Message-ID: References: <4c2a6100-738e-48cc-8a11-2d85f95ae0ed@app.fastmail.com> <18a111db-9f31-449c-a14b-61779a69f344@app.fastmail.com> <1503201.1745444021@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1503201.1745444021@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, Apr 23, 2025 at 05:33:41PM -0400, Tom Lane wrote: > Nathan Bossart writes: >> Here is a new version of the patch with this change. > > I don't see any comments in this patch that capture the real > reason for removing pg_replication_origin's TOAST table, > namely (IIUC) that we'd like to be able to access that catalog > without a snapshot. I think it's important to record that > knowledge, because otherwise somebody is likely to think they > can undo this change for $whatever-reason. D'oh, yes, I'd better add that. -- nathan