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.96) (envelope-from ) id 1wGLXJ-0067xS-1D for pgsql-hackers@arkaria.postgresql.org; Fri, 24 Apr 2026 18:45:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wGLWI-007KCn-0W for pgsql-hackers@arkaria.postgresql.org; Fri, 24 Apr 2026 18:44:54 +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.96) (envelope-from ) id 1wGLWH-007KCf-2Z for pgsql-hackers@lists.postgresql.org; Fri, 24 Apr 2026 18:44:53 +0000 Received: from mail-yx1-xb132.google.com ([2607:f8b0:4864:20::b132]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wGLWF-00000002roW-28qV for pgsql-hackers@lists.postgresql.org; Fri, 24 Apr 2026 18:44:53 +0000 Received: by mail-yx1-xb132.google.com with SMTP id 956f58d0204a3-6563f83ae9fso1960577d50.1 for ; Fri, 24 Apr 2026 11:44:50 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1777056288; cv=none; d=google.com; s=arc-20240605; b=jwNaYCBJYh0+r5HZbwA7C+B4lpJMuktGSCjncFJ5+D41+YlKfvQOms3A4l1waW41yw sMrME+e29rH1G9ovonfy3F4rn++XII7opVR9m6IgmbWDdEmr1smwwtc4jDh1hPdV81Lm dJoGwkMfe4Ai04VAmc/GBtxtjrpwnUfd0VN26C0B5nmh+S4E46CaJ+zljchpK5WwpyCf l9e8UlhIX1S9bNx6vWKaoKHFYWSBLpFfGP41A+XreBsqDozkjvXADmwn4AD5kQ68lOAw 1fVFFC9GBhCg1qR2qDzrhfh0E90j1j90uKWSS/HyyCIMpxjyZwf7q4pkMHN1zJ2eiLuS OYwg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:dkim-signature; bh=ujah39dcjs6jJmiOUq0D9egM7LmD/Nn9AL7Da705lPU=; fh=Mmdrcjz5UqkUwsYRq0kIwzzVt8OxCjnIr7ofpDpgtAY=; b=aTJzbOENYeFfGn6G/5wl1DguSGePeR/EW9DpTp3pTQt21+eaIepu1LOWQj4DLsUa2V 7pRaYy2kqdLK2QHsK653MQI6HiXUEzRJ6lKX3upwdxutYZosSq/gIZ3hXtEriraoRw1Y aJt+fozZQuFEe34c5RJzNTRwetYdxTDG0nZo5J1lB+j2vm2ZlNcjQhPtebo65eGfHTDw aqKNQTwxcAmLFy6RyKEEDhdEMR3NScjFxvR36pYUIM2A5p3XWuylN9adsgxb/VEjYPsE oh7Td0BXsYFbUZ6iObauU4zTfxV0XWl0oXqsnDbJ8Xk+G9+Wk9zNps1L3Rn5MsxXHjJq DwDA==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1777056288; x=1777661088; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=ujah39dcjs6jJmiOUq0D9egM7LmD/Nn9AL7Da705lPU=; b=njnHLwKzklTTE4rTDNZE5iLjJCb/NcVJ5aE58CTnXZoWx4uUdO7Pt8eu7a9jLeqJlc c3j/0DPqF/bxT9bBWat+PLSQkir5xfQ/chA9gfPcJuEbMnjzkfFS7Gn1P4OJMCv2tdk+ DUt4FW0v0P/Sp7CAWHm75Hw7ywakF6IyBe6p0j43xodEZHGm2xu2H/Qg5dbEfZKFZskJ ada1LJDBWREGjNcWwT/GomoOm6VXkZ+ZJvXNEWWne+O+yuMXCHjqG6SNJFr2aeDlEtSZ ClyW9HzbMuumijM+myhK9M3LJ8FCP3fy4MK+DDfLHgZMRkSQh1C1bUzLA8klitozBzbe RJLg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1777056288; x=1777661088; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=ujah39dcjs6jJmiOUq0D9egM7LmD/Nn9AL7Da705lPU=; b=aEfdSdsPBqyeMJ3XZCZRqcfsFtwwQRrYupWnuvOz+Hl6Yr5BnBXAsQGljcyGbuOhJi uvEavTbVLC5p9UWZjqkCzKCpDPslmeVrexA6kfDSVR1DDKxjp1qFeP9y9zy/aV5gULeD QfkMm7H1uhLx5Ot7Kw4K732fx+l9+02/k36VoIaFvHGOXKSCuYIKvusjKAnD5XboYp1B 4rk/1LEpHdQNyfQwpa4VB8utCd1brX0k0vNxb2uu8ZefYL/zcrRAb/ohDRcq/cqQTcLP fE8sGts9yqP63FKBkKJzIBNKgiKxQFVrW5ySV4D+pldZGj+UQCyPsUm+aBKOfT4iRQGf TXDA== X-Forwarded-Encrypted: i=1; AFNElJ+XhyQhKmPvUR4LOUewO40/N/GaypbL0uCZ6LVc6R81h2M4JfZQlvkiMcIc7xgAAA0uOlqN9/fnzRFMaEa1@lists.postgresql.org X-Gm-Message-State: AOJu0YxmlTg6qHQSI5WCZiKIytqzxHdTgzX9qxCPrPOvOTDBqRyHeoqD LmqB6eeOa3va/Dwu9WNa1c/U3502j4CClfXFCP0HmQPjk/ufj6VQlyMmq6zfFVjjGL0Pl41drAp Pypcw3AjUF28M0I1lDLt3CizC8pLLQv8= X-Gm-Gg: AeBDieuxUtjyI/Jermadthio4Etdp0u/9SDfSuTpRtM1uyMNyj6zeAmk+jEvEbDtMHe NpP29ypwKFsmaC2wwvadZEJoIEhBersHKP62stVLgJBfkiuUsODqy/R73UtfyhqLfJhEFEeQCwu NtdREqH8HJ3uTuuTOF2OWpzLlVlK/ZzmwaMkPgiI1lHSF/4SfnRi8SS7aPcnaQ4/QlNngZfSYqK gt+112lz8GE6PiFQ+C56kPAwQ0IFtg2qt7TZSRy2ptREWmhQtmDThMzKA0PDzTCXgfhrijzQxNm 9Ek8Cz6qRUJ4Iq//HqNvPoi2VGb7TECrgNFoXABNufZ71P3lPA== X-Received: by 2002:a05:690e:1914:b0:655:dad2:56bf with SMTP id 956f58d0204a3-655dad25b53mr6544031d50.17.1777056288258; Fri, 24 Apr 2026 11:44:48 -0700 (PDT) MIME-Version: 1.0 References: <8afecd87-d1e5-241c-5e3e-75e1c62c279b@enterprisedb.com> <1bc5e1e4-380b-213d-6e6a-d5e8f7f0c7f5@enterprisedb.com> <84ffb566-8038-ab35-c841-7a5e5728a247@enterprisedb.com> <525ea957-88ff-e2c6-2975-474c849aa234@ulb.be> <48a78946-f380-a279-e75f-711846e509f8@ulb.be> <4c443cf6-96af-0953-fd5b-bd2b5c0c6f00@ulb.be> <2516071.1699991181@sss.pgh.pa.us> <08b2dea8-6dca-06e4-a53d-3e6334e7645b@ulb.be> In-Reply-To: From: Haibo Yan Date: Fri, 24 Apr 2026 11:44:34 -0700 X-Gm-Features: AQROBzBzYFcuYr4eFx36DUmeW99qSBsRsWaD1dUUlPhDriijrg47PNq8jVC90uY Message-ID: Subject: Re: Implement missing join selectivity estimation for range types To: SCHOEMANS Maxime Cc: vignesh C , Tom Lane , Damir Belyalov , jian he , PostgreSQL Hackers , SAKR Mahmoud , Diogo Repas Content-Type: multipart/alternative; boundary="000000000000cec02206503928b1" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000cec02206503928b1 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Thu, Apr 23, 2026 at 5:32=E2=80=AFAM SCHOEMANS Maxime wrote: > Hi Haibo, > > Thanks for creating the CommitFest entry. Could you add Diogo Repas, > Zhicheng Luo, and Mahmoud Sakr as authors as well? They wrote the > original patch and the underlying algorithm. The earlier CF entry is > at https://commitfest.postgresql.org/patch/3821/ for reference. > > Of course =E2=80=94 I=E2=80=99ve added Diogo Repas, Zhicheng Luo, and Mah= moud Sakr as authors as we > Regards, > Maxime > Thanks for the reference. Best regards, Haibo --000000000000cec02206503928b1 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

On Thu, Apr 23, 2026 = at 5:32=E2=80=AFAM SCHOEMANS Maxime <maxime.schoemans@ulb.be> wrote:
Hi Haibo,

Thanks for creating the CommitFest entry. Could you add Diogo Repas,=
Zhicheng Luo, and Mahmoud Sakr as authors as well? They wrote the
original patch and the underlying algorithm. The earlier CF entry is=

=
Of course =E2=80=94 I=E2=80=99ve adde= d Diogo Repas, Zhicheng Luo, and Mahmoud Sakr as authors as we=C2=A0=
Regards,
Maxime

Thanks for the reference.

Best regards,

Haibo=C2=A0
--000000000000cec02206503928b1--