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 1mt3Hf-0007h3-5A for pgsql-hackers@arkaria.postgresql.org; Fri, 03 Dec 2021 07:47:07 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mt3He-0004J0-0B for pgsql-hackers@arkaria.postgresql.org; Fri, 03 Dec 2021 07:47:06 +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 1mt3Hd-0004Ir-N4 for pgsql-hackers@lists.postgresql.org; Fri, 03 Dec 2021 07:47:05 +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 1mt3Hb-0006hX-OE for pgsql-hackers@lists.postgresql.org; Fri, 03 Dec 2021 07:47:05 +0000 Received: from compute3.internal (compute3.nyi.internal [10.202.2.43]) by mailout.west.internal (Postfix) with ESMTP id 9324B3200FA2; Fri, 3 Dec 2021 02:47:01 -0500 (EST) Received: from mailfrontend1 ([10.202.2.162]) by compute3.internal (MEProxy); Fri, 03 Dec 2021 02:47:01 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= date:from:to:cc:subject:message-id:references:mime-version :content-type:in-reply-to; s=fm3; bh=Tu2goRR1iPN+JE4F2/KhYKVKJfS J0hh9pq/m2b/7lic=; b=mm1UhniVjY3HcDpn+aEoi6NB3ZhbCa9MtX4WMgZ8roO rpKr/7Dt643Zjk9CJFGhWF0VY7JyhqvWdfz8aXORcKSBB4+M5ZrQYULclEgUVzeD 7/9h3clJihWN05WruQX+OuJ54XZxCgiBuOuHNaMefPQvXwAUGW2seMFKbFC9ayob jf94fCfmEtNMPph5ImC12PadsmsCybDJZPni5UFFluiaZmfiWVBFkwnkfK1dbrqT 8j+kmlNYR1fq8OHv9Bfu1fvOar+Tkp6KkzIMpkntQHw+rpuNas4QABgjyJacN1ES rDRWiKxJ6d6v3dWO3VTp7m3i8XbN+yUWkvXfHaDyuwg== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm1; bh=Tu2goR R1iPN+JE4F2/KhYKVKJfSJ0hh9pq/m2b/7lic=; b=cIW6arXx+fR5LuxfHx6Git T7JANcvccIegMHpQDfJhHf5W/sGf40AF9+4nknwA1MdW/vou3VeR7YjU/8QxMkYy PBpB/2iX/BpE4KK7GoXZPunUDTtTapgT+8sA1iMQBmFqhYr6KUcEGKwJ1MeHcTvJ dYaaNTBmPZ/+S393NTHH63TqKp3p6AZTcjYsi/v5TM9duy/ZLgEqNvqF4f9eYPeX 9AT/0ETyQuJPBXikRtdR7NiH4SvecPATzTEOE/7nD1IrMi/hbZdPDZsJDVvaQnvr PrZcihtn2TfpGmbIVIZ9xR57ugELaDH3K9ZLZ3pbisAf+SoTz5RSiBF6BL9Yd2rg == X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvuddrieeigdduudegucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne gfrhhlucfvnfffucdljedtmdenucfjughrpeffhffvuffkfhggtggujgesghdtreertddt vdenucfhrhhomhepofhitghhrggvlhcurfgrqhhuihgvrhcuoehmihgthhgrvghlsehprg hquhhivghrrdighiiiqeenucggtffrrghtthgvrhhnpedvgeduuefhtdeuleettdevjeeh heeiveeuieegleetgeeljeelieeuieehgeevhfenucevlhhushhtvghrufhiiigvpedtne curfgrrhgrmhepmhgrihhlfhhrohhmpehmihgthhgrvghlsehprghquhhivghrrdighiii X-ME-Proxy: Received: by mail.messagingengine.com (Postfix) with ESMTPA; Fri, 3 Dec 2021 02:46:59 -0500 (EST) Date: Fri, 3 Dec 2021 16:46:56 +0900 From: Michael Paquier To: Tomas Vondra Cc: PostgreSQL Hackers Subject: Re: PoC: using sampling to estimate joins / complex conditions Message-ID: References: <580ba824-7630-e6e8-f80f-725dfa587da5@enterprisedb.com> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="JOT1atSAD++LylpZ" Content-Disposition: inline In-Reply-To: <580ba824-7630-e6e8-f80f-725dfa587da5@enterprisedb.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --JOT1atSAD++LylpZ Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Sun, Jun 27, 2021 at 07:55:24PM +0200, Tomas Vondra wrote: > estimating joins is one of the significant gaps related to extended > statistics, and I've been regularly asked about what we might do about > that. This is an early experimental patch that I think might help us > with improving this, possible even in PG15. The patch does not apply, so a rebase would be in place. I have switched that as waiting on author for now, moving it to the next CF. -- Michael --JOT1atSAD++LylpZ Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmGpy3AACgkQnvQgOdby QH1yMxAAm82N/Fs/tTf1cWTbN3NeT/5y4zxnOYYQSFwSHwe3JOnjOEOmoYDSnxyG VW7cMbl5TENHx4NaO2rQ1kiFY0XYSLceh/SFSOxgpkcQdh/gJOiScPS7ZG6FB9nz G59htFgzHCyjz8dFqpgTE+n6qFNEVFW0VvYDKkceg7+ninisNWz8h5KZ6/KhZEKP llcQhtEagirbntc2L3PI26Y9x74JaRuESeDG59hl7J/HBOoZzYzyTBo4JigmnN1e o3WtOEMuwiiemNHidh1D+4uV4u5l49NSmhRaez7djHXy/9dwvXBtIWrdwSRZPBHN e5URoO7PJ8lHAWr367uQQtIH27uQrcsbce4fHr3pBRtE4QbCyxOF6CUG5l6+dmVM hP2H3hsjZM7Aie2u5W8cPPv6fu/E5NjipQEhpGyywFtXeizwkhYNTNecgJU8ZLio kIbY0JKlXXLO5Aqyrvob2ADxNPZJuzhyPA2bUrk3W0vEFlyjKANQE+y0frz0vZ6V nVviEK36Yf/ac2DQ8TfBSUex2Beiv2prWJ1/yghEZLSzgb1GhdDki9n9ZpywtUJC hAAj9WOpmbdYDJdp8MLrxe2fp1zhGSKYJhlwVycmaxhIhRfUKRrD4IjQn2XYZBl5 8VdurMm4gz/yNrffotTYecqj65xywjK3mw4IsPnhmhUHniP5/KE= =JxhO -----END PGP SIGNATURE----- --JOT1atSAD++LylpZ--