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 1srgpf-003o3F-AH for pgsql-hackers@arkaria.postgresql.org; Fri, 20 Sep 2024 16:50:12 +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 1srgpc-009ur6-4J for pgsql-hackers@arkaria.postgresql.org; Fri, 20 Sep 2024 16:50:09 +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 1srgpb-009uqy-RC for pgsql-hackers@lists.postgresql.org; Fri, 20 Sep 2024 16:50:09 +0000 Received: from mail-io1-xd35.google.com ([2607:f8b0:4864:20::d35]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1srgpZ-000DUn-Ep for pgsql-hackers@lists.postgresql.org; Fri, 20 Sep 2024 16:50:08 +0000 Received: by mail-io1-xd35.google.com with SMTP id ca18e2360f4ac-82fa0ccb0cdso100680239f.3 for ; Fri, 20 Sep 2024 09:50:06 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1726851005; x=1727455805; 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=t6r34bG/7ntXFcRhAiEbh2z810TiNG0fNECEU8S/0cE=; b=TrYLpyi2AROjFsKAJaUPxD3LsJZXnqyUdhhfOVOxPlvgjntQsta7Fy5yK//bcV0M6Y plcj3P3VGHljG4g4FETAClkOd4B9zaUmTE5MPkbWZ5OTGvkMhkL0OWWiThLuW8bkUNAY vso+Qy7hgEMhJ7J+SNeeNSLCM2ZsogsY0brNaCHhd+TKQ/JdAvHTJ5A19kznNFqqa8dK VmRTaNjf29fvYo4lcdPEDCcrkipYZ/ZLkUD2I0BQfkIOcEZXtMVeqVDBAPPCnfhg6Rzt Z1hnCe9onDNemZRP7W9vli+q3IJw+5bWjTk9J0Hr7i0sevJ0dc5iZMLKVctaznq37vib VLqA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1726851005; x=1727455805; 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=t6r34bG/7ntXFcRhAiEbh2z810TiNG0fNECEU8S/0cE=; b=G9+64Rj9J8KyEGVcFY6cXVfPpSbkQ9WH186DfyIKlPkAg/84A7mhXUx/HyatveJ2FL xVZpJU0pKXp+F7YfopnABsoOPHCRL9D0xhdSp64+flCOquxEm1fmclETVHW/EAFGkNPH cfE9T+CV8C8E9deVZlk8kLKI7xTfHMq6v9TxWD1d2/O/7WKbTV/WXLSkAVwveUI2Gj+h fONfZ2TDW2E/aPWu1ttjNOyt9AGLDqugoj9MTBf3X6rotk7y2Iln0RjKg1X0w5BzXRUu h1ua1IBdA4d0tvXE0OHYoScHbW+Gq22LTE/y8guRAco5QqWYh09scSVU51WbxMHicfwa gDhg== X-Forwarded-Encrypted: i=1; AJvYcCU0Gd4qQkW25kDq3tAOm57FC7fbfqpqLXzlNyL/SvwndkmENs+GBeMEeHHCYAYHKx1SKWxkmHYJp80Ii0Sp@lists.postgresql.org X-Gm-Message-State: AOJu0YxRBFvcwaCEJmRsQ2dl6gc1rE0oU8tU5mkxPQD89mCjHhpBJNYN hur8S80vd9QV4NMkPcEnYzwXRsk8VQSzn6XVg8fJXxi7alm/0Q7h X-Google-Smtp-Source: AGHT+IHqgBRRdht7R87kalDmJkauASuCV5bvbjfAZpqw2zMG9JefiqKwAvxK0FJ9qJX1JT5ZiqTAEw== X-Received: by 2002:a05:6602:2c0c:b0:82c:e8d2:f86b with SMTP id ca18e2360f4ac-83209e8dd8cmr448278839f.14.1726851004631; Fri, 20 Sep 2024 09:50:04 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id ca18e2360f4ac-82d49355ec0sm389819939f.46.2024.09.20.09.50.03 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 20 Sep 2024 09:50:04 -0700 (PDT) Date: Fri, 20 Sep 2024 11:50:02 -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: <1679756.1725476893@sss.pgh.pa.us> <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 Fri, Sep 20, 2024 at 08:16:24AM +0900, Michael Paquier wrote: > Perhaps the reason why these snapshots are pushed should be documented > with a comment? Definitely. I'll add those once we are more confident that we've identified all the bugs. -- nathan