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 1stvUb-002kS8-3j for pgsql-hackers@arkaria.postgresql.org; Thu, 26 Sep 2024 20:53:41 +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 1stvUa-00E96A-D6 for pgsql-hackers@arkaria.postgresql.org; Thu, 26 Sep 2024 20:53:40 +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 1stvUa-00E962-3m for pgsql-hackers@lists.postgresql.org; Thu, 26 Sep 2024 20:53:40 +0000 Received: from mail-il1-x12e.google.com ([2607:f8b0:4864:20::12e]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1stvUW-001FNm-DX for pgsql-hackers@lists.postgresql.org; Thu, 26 Sep 2024 20:53:39 +0000 Received: by mail-il1-x12e.google.com with SMTP id e9e14a558f8ab-3a0be4d802cso6145615ab.0 for ; Thu, 26 Sep 2024 13:53:37 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1727384015; x=1727988815; 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=bb1Xzf51W61/2n61WNk4LNEIAHzec5XGOPCr1zgqbJM=; b=Jkxc/QOHBhC80IWkj0cf5U7P8OD7oqN+xCZrbKL4x3aWmLZWEjDe+xpC4dUg61DQ6D aFt8leFt4TcZUcW7flUixKtRm6ynceKWrOxXHZGSzbBGU8opQDuT+37MhpMCOskBpcRM AKpQrUeB2h+6tPABi1HktOSKCN5Qvg4BYHd/EwNBlHn6c5qtyGKtPnoiO5If7wQ6AVTA q/7ExmLLv7JbiJyWm8CxlqVHWmUIxYDk8bjXHH4WCuVG8lXvYu0xUSp2YgkIeWq81yC0 RlwNl3WO81BGduGq0GwlqBfVWFSNB7uOH5rzYvzjv6qljuyUAKHQNo9cwaJpAW3ggB8O vW5w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1727384015; x=1727988815; 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=bb1Xzf51W61/2n61WNk4LNEIAHzec5XGOPCr1zgqbJM=; b=AQViryIL/m7YQijJ2hE4k7DBC/ZvO9SqtmvOG5YnGsyt2KvttpO5ELacLKAkxvt/xZ GD+29gMS9syjxB7N4qcguuX8huciNcN01XUWaq4X9R2BaZY7Yi+Av1tRtfqD8Db0PwaA OkrztaUAe6JqsckRG1Fye3fwSZ9gGp7DZdWBoStQu6u8iqMMJEth7SCsm9MSBDfHO/7P sSDEjx7cQg33sjyNEBoghO056WiMuTAQbVIMTKBrVuSKwYaYWiZ+Hi+nLkoa4uwmCFgF ytHRzmjPkAUfgHOY27mVLUQGDC+3wjHpOMz5XpkZT0H3u/+eIJ1ImerygtYBo1BiyPBT K8XA== X-Forwarded-Encrypted: i=1; AJvYcCXHpJfl4ru2hwl+tJIZTX809YTPquIqSrQ/AlDFWwymm6MNXp/q4oNEuLtlDe02smHAYIUZmGAjGDFd/gem@lists.postgresql.org X-Gm-Message-State: AOJu0Yx8lBuy19/NQsJntzXQKwMPTyHYrfe8R0edtkV41eH121SXClkZ /LvfWv/HZ6i1acKGYRFF5R99BcAU+yS6C75ROyFe6tSY+ZY2m54o X-Google-Smtp-Source: AGHT+IH6nK0ZxaUyUpUgOeTAe949k2iyTDXeuUh4o8gq+utN0PzqEh2S3jBRaNYP7VbHL0YiFICzdQ== X-Received: by 2002:a05:6e02:154c:b0:39f:5d96:1fde with SMTP id e9e14a558f8ab-3a34516009dmr6633565ab.3.1727384015395; Thu, 26 Sep 2024 13:53:35 -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-3a344de1f71sm1267725ab.55.2024.09.26.13.53.34 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 26 Sep 2024 13:53:34 -0700 (PDT) Date: Thu, 26 Sep 2024 15:53:33 -0500 From: Nathan Bossart To: Michael Paquier 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: <1812111.1726671296@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 Tue, Sep 24, 2024 at 02:26:08PM -0500, Nathan Bossart wrote: > On Tue, Sep 24, 2024 at 01:21:45PM +0900, Michael Paquier wrote: >> On Mon, Sep 23, 2024 at 10:50:21AM -0500, Nathan Bossart wrote: >>> I carefully inspected all the code paths this patch touches, and I think >>> I've got all the details right, but I would be grateful if someone else >>> could take a look. >> >> No objections from here with putting the snapshots pops and pushes >> outside the inner routines of reindex/drop concurrently, meaning that >> ReindexRelationConcurrently(), DefineIndex() and index_drop() are fine >> to do these operations. > > Great. I plan to push 0001 shortly. Committed this one. -- nathan