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 1oiUAp-0006cn-6v for pgsql-hackers@arkaria.postgresql.org; Wed, 12 Oct 2022 05:20:55 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oiUAn-00084M-Vm for pgsql-hackers@arkaria.postgresql.org; Wed, 12 Oct 2022 05:20:53 +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 1oiUAn-00084D-Mr for pgsql-hackers@lists.postgresql.org; Wed, 12 Oct 2022 05:20:53 +0000 Received: from wout2-smtp.messagingengine.com ([64.147.123.25]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oiUAl-0002CS-Ky for pgsql-hackers@lists.postgresql.org; Wed, 12 Oct 2022 05:20:53 +0000 Received: from compute5.internal (compute5.nyi.internal [10.202.2.45]) by mailout.west.internal (Postfix) with ESMTP id A0BD2320085B; Wed, 12 Oct 2022 01:20:49 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute5.internal (MEProxy); Wed, 12 Oct 2022 01:20:49 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:cc:content-type:date:date:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:sender:subject :subject:to:to; s=fm3; t=1665552049; x=1665638449; bh=qMvg0f3KUE dH3RTkusdQ3GUf3eo1cqG2AhxpwOz/k/g=; b=cUr/PCFLzi3k3oANvsWtbNgME7 jPagbA4kG2PUhmvzgRGZQ0Leh2YtHqVhi+MYN0zWb9pUfG2EZYom8XpTeKC3cyP0 jFp1rBR14fBBg6KXEfr52aEkN3z07dssrbqBEckvTXbkJpgyd6/wpPqN+B0tiDi7 WprMiy3lulNa+3EJJQk90aPlqypQ5hokXD09P0m0XsoC17ZlVTDtR5QJrT+fYcZK fyL4ALv+KpNZb5sLTvjWozSARVE+Y7j3GZkXckXpt3Zi6D6J8T1ZdYmmokGYr4Ra iepjyyttJZ/OKDrevKTQySkWO98eikeZi6XIrEBOgiglPKb/GuQa5s1BOoLw== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc: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= fm3; t=1665552049; x=1665638449; bh=qMvg0f3KUEdH3RTkusdQ3GUf3eo1 cqG2AhxpwOz/k/g=; b=ktZpPNjnFpJVIFGPj+sVcry35tjj4un1ufhgJhyG3uKh gMMBbIkd6gr2zx+AgcynruKSIZFt33MN8ucvuU5T5nFyWVUqYwHH8oPT967K1G5z AkREEEESxYhVJ/emVETwBSoQjXuo4seKSM1ArMHeZet7pYWJdCJ5niDtMc7PQJ0V OaJg16wAgvYKO7dijUOSkWmFtXbrbWvR5PM7A0pJl6tDdXWwttTlXtsOzzRXYp/5 rrjHAqNTOsHO+OiiNF5D82Ne658NdbY4lfE7BXumL4j/q49gSXHz7FDhY6l1TZCA /JHm5jUSqU26JsA+LOAnuefcv6HChPSkdrI1fSs6tg== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvfedrfeejjedgleehucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne gfrhhlucfvnfffucdljedtmdenucfjughrpeffhffvvefukfhfgggtuggjsehgtderredt tddvnecuhfhrohhmpefoihgthhgrvghlucfrrghquhhivghruceomhhitghhrggvlhesph grqhhuihgvrhdrgiihiieqnecuggftrfgrthhtvghrnhepteelieefudffhffhtdetleeg geegfffhkeeuveetiefgudduvedutefggeeivdejnecuvehluhhsthgvrhfuihiivgeptd enucfrrghrrghmpehmrghilhhfrhhomhepmhhitghhrggvlhesphgrqhhuihgvrhdrgiih ii X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed, 12 Oct 2022 01:20:47 -0400 (EDT) Date: Wed, 12 Oct 2022 14:20:43 +0900 From: Michael Paquier To: Ronan Dunklau Cc: Tom Lane , pgsql-hackers@lists.postgresql.org Subject: Re: Fix gin index cost estimation Message-ID: References: <3188617.44csPzL39Z@aivenronan> <4212593.ejJDZkT8p0@aivenronan> <3871020.1663358699@sss.pgh.pa.us> <4768224.31r3eYUQgx@aivenronan> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="3vo4eZFC/ZS5bD8f" Content-Disposition: inline In-Reply-To: <4768224.31r3eYUQgx@aivenronan> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --3vo4eZFC/ZS5bD8f Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Mon, Sep 19, 2022 at 09:15:25AM +0200, Ronan Dunklau wrote: > You're right, I was too eager to try to raise the CPU cost proportionnall= y to=20 > the number of array scans (scalararrayop). I'd really like to understand = where=20 > this equation comes from though...=20 So, what's the latest update here? -- Michael --3vo4eZFC/ZS5bD8f Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmNGTqoACgkQnvQgOdby QH2XmRAAiLWMb2P+x1VmeLMNXpiTbPMWWjSTuz6To38KCO7lxSP4dJJ7/2eR6sV4 on8t/hcyYYBq2sUH0S7SnYwthn5Rx3mMRuXTcOJkp8OUwEb1w0sDQXJJ1v1Mz1gc x2eviCdbR0/z2FX+5pkkagzSd/HwssgdAsKxSjVQEqOP9bW0HIfkcJRHN8uZLAZ8 FslsjGwgzeSL6on8w50a8ckR6qkdUsxyAyVpItKUgjWpqjS2AHtK4jeVT24I4bnq XQ6jgL0XZPr/fHMGcad8F3quD3lFk3HUa4HVZYJt7s8A+76Im/tibg1ZIngZkaOv uMn0wy29aPzIRLsI4PHJWThZLJVbodSmCZfKSkw0hJ360Hrjxv2ZD4Ua1ZGB4QCi Gy+O3PpxxCDijbDa35JytA2xFxeAB/ADRdPHUNfs5d9k8ByBDjd2Z9GWQz9baXe1 7fHVBSLRK3uRKcamqAJYgLfk+yb0ia4EmwCGyCtQ2HqwDRmtcI3LuuH3Y+X96nE8 KoC4t0OW1dDu2YtC6XdNUA+z9ar835eVKqHPDaTsW3Hhhjnn1d9YvkR0kKafesKr lcuuXSy4zh56WeA7WySOa39UxYlPtlL0dTebZeRaLs7WIWE3tkyFuvI15vH6qHCw P7Gxljx6lmIk6+HozsGIj2K5NdUgFquM23rfswjCvUFIQHDwHUo= =oKUC -----END PGP SIGNATURE----- --3vo4eZFC/ZS5bD8f--