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.98.2) (envelope-from ) id 1xRApE-00000000kXE-3s6W for pgsql-bugs@arkaria.postgresql.org; Wed, 11 Nov 2026 16:05:28 +0000 Received: from localhost ([127.0.0.1]:40930 helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.98.2) (envelope-from ) id 1xRApD-0000000C1I5-2XKT for pgsql-bugs@arkaria.postgresql.org; Wed, 11 Nov 2026 16:05:27 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]:58870) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xRAp8-0000000C1Hx-1PJd for pgsql-bugs@lists.postgresql.org; Wed, 11 Nov 2026 16:05:27 +0000 Received: from sss.pgh.pa.us ([68.162.161.243]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xRAp7-00000000On5-21ld for pgsql-bugs@lists.postgresql.org; Wed, 11 Nov 2026 16:05:21 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.18.1/8.18.1) with ESMTP id 6ABG5Jfc3243343; Wed, 11 Nov 2026 11:05:19 -0500 DKIM-Filter: OpenDKIM Filter v2.11.0 sss.pgh.pa.us 6ABG5Jfc3243343 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=sss.pgh.pa.us; s=default; t=1794413119; bh=D79ooBTB/uDeNvSeBUe1o2zKSyyRbyBjzqX1iIcl4mc=; h=From:To:cc:Subject:In-reply-to:References:Date:From; b=wh0rvg2qS6DymeC5GtT5l2xynnEafMl5gf9NP6uBmNTaJFbQefTO5gLJsNhV55zm6 s/c/qs8fITabkupR0iY6/I3C7sXU8m5VLIvyLyl16Qi2cnTYyuIZ5yOz8dnpra8NQ8 mArixz3Q8+Yuw2f8RNELCjr1Q4SX/cXNqBVqLyw4= From: Tom Lane To: shihao zhong cc: Michael Paquier , Atisss hh <125atishprak@gmail.com>, pgsql-bugs@lists.postgresql.org Subject: Re: BUG #19849: queries fail after ANALYZE with expression stats on arrays In-reply-to: References: <19849-38b8bd2fea807154@postgresql.org> <2492770.1794253395@sss.pgh.pa.us> <2925331.1794336781@sss.pgh.pa.us> Comments: In-reply-to shihao zhong message dated "Tue, 10 Nov 2026 20:17:27 -0500" MIME-Version: 1.0 Content-Type: text/plain; charset="UTF-8" Content-ID: <3243340.1794413119.1@sss.pgh.pa.us> Content-Transfer-Encoding: 8bit Date: Wed, 11 Nov 2026 11:05:19 -0500 Message-ID: <3243342.1794413119@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk shihao zhong writes: >> Does anyone else feel that way? > I’d pass all three key columns because it is weird that two come from the > arguments and one comes from stats. Done like that, then. regards, tom lane