Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pQ70m-0001UI-SP for pgsql-hackers@arkaria.postgresql.org; Thu, 09 Feb 2023 13:30:53 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pQ70k-0007RX-R6 for pgsql-hackers@arkaria.postgresql.org; Thu, 09 Feb 2023 13:30:50 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pQ70k-0007RO-1l for pgsql-hackers@lists.postgresql.org; Thu, 09 Feb 2023 13:30:50 +0000 Received: from wnew2-smtp.messagingengine.com ([64.147.123.27]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pQ70g-0003u3-EX for pgsql-hackers@postgresql.org; Thu, 09 Feb 2023 13:30:49 +0000 Received: from compute3.internal (compute3.nyi.internal [10.202.2.43]) by mailnew.west.internal (Postfix) with ESMTP id 63BA72B068B0; Thu, 9 Feb 2023 08:30:42 -0500 (EST) Received: from mailfrontend1 ([10.202.2.162]) by compute3.internal (MEProxy); Thu, 09 Feb 2023 08:30:43 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:date:date:feedback-id:feedback-id:from:from :in-reply-to:in-reply-to:message-id:mime-version:references :reply-to:sender:subject:subject:to:to:x-me-proxy:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm1; t=1675949442; x= 1675956642; bh=eYFr05AThImZqqIfioPj0fPsUNEWzZo0v9puGs1RB9g=; b=d geHMzfsBqAOXDsEzNEcgZ8IGjRhNZiLetwCwWEQTP34RzO68I0RjcNSfMx8pMrJ5 s4Yz8TCkgE1I+/dO3PGis3yxXwejJGiNqn/v8CU+E6LygKlMZgeQ6cQmbWRKs1uE aybQfOd7PUHMmQDEfsvKiuVLBCzMvf3MYril0uLiA+tgcJ4nQCU9gj8jkck/gZjs NxuIPsWcs7qDqVxNxYB7UOXixM2DbO2HpHtJzqq8c6pqMYMtTOluQgPvTmavecpd ywQU1LgK7K5R+UXensP+0QHZmU2a2Ur/6qCqkCB5CLIA+8HQU2seMC8Jwv3fH9SI gUvUFncOwFZiZ3DnL/ARg== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvhedrudehfedghedvucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepkfffgggfuffvvehfhfgjtgfgsehtjeertddtfeejnecuhfhrohhmpefrvght vghrucfgihhsvghnthhrrghuthcuoehpvghtvghrrdgvihhsvghnthhrrghuthesvghnth gvrhhprhhishgvuggsrdgtohhmqeenucggtffrrghtthgvrhhnpeehleffgeegudejteei hfelteduvdeifffhffdvjedvffegjeekudeludehudeifeenucevlhhushhtvghrufhiii gvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpehpvghtvghrrdgvihhsvghnthhrrghu thesvghnthgvrhhprhhishgvuggsrdgtohhm X-ME-Proxy: Feedback-ID: i131946ab:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Thu, 9 Feb 2023 08:30:38 -0500 (EST) Message-ID: Date: Thu, 9 Feb 2023 14:30:34 +0100 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:102.0) Gecko/20100101 Thunderbird/102.6.1 Subject: Re: pg_stat_statements and "IN" conditions Content-Language: en-US To: Sergei Kornilov , Dmitry Dolgov <9erthalion6@gmail.com> Cc: Michael Paquier , Alvaro Herrera , Marcos Pegoraro , vignesh C , Robert Haas , Zhihong Yu , David Steele , PostgreSQL-development , Greg Stark , Pavel Trukhanov , Tom Lane References: <20230129133219.tpuzqbyqw3ojztbd@erthalion.local> <20230202140727.g7tw7qjo43g54wcb@alvherre.pgsql> <20230202150554.dwxhvw23epcskppb@ddolgov.remote.csb> <20230204170841.xfgxoo7ymwbvu7yx@erthalion.local> <20230205113346.gmbf5ycnukuhnmqa@erthalion.local> <2420105.1675612952@sss.pgh.pa.us> <20230205195600.e3bhwszzm5kdyyxl@erthalion.local> <966631675800892@znolar4klagewshm.sas.yp-c.yandex.net> From: Peter Eisentraut In-Reply-To: <966631675800892@znolar4klagewshm.sas.yp-c.yandex.net> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 07.02.23 21:14, Sergei Kornilov wrote: > It seems a little strange to me that with const_merge_threshold = 1, such a test case gives the same result as with const_merge_threshold = 2 What is the point of making this a numeric setting? Either you want to merge all values or you don't want to merge any values.