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.94.2) (envelope-from ) id 1u2fwP-004ERN-Gf for pgsql-committers@arkaria.postgresql.org; Thu, 10 Apr 2025 00:38:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1u2fvP-008HIj-2P for pgsql-committers@arkaria.postgresql.org; Thu, 10 Apr 2025 00:37:47 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u2fvO-008HIa-RO for pgsql-committers@lists.postgresql.org; Thu, 10 Apr 2025 00:37:47 +0000 Received: from mail-qt1-x82c.google.com ([2607:f8b0:4864:20::82c]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1u2fvN-003yEx-1k for pgsql-committers@lists.postgresql.org; Thu, 10 Apr 2025 00:37:46 +0000 Received: by mail-qt1-x82c.google.com with SMTP id d75a77b69052e-4774193fdffso2947131cf.1 for ; Wed, 09 Apr 2025 17:37:45 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1744245465; x=1744850265; 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=ZHrhc0OqrC98GB81DIBmeDu/0yj0Eidgx+ZJARRB9QU=; b=N3iz/q/yj54yf9LtZJqW6E/cj3ngiSed0apfns7p9pmIMkrXkRwLn+q3wJdbF1hk1S GZWkGMe9cR5KH0MEj+f+TguhCp7RsJO1z0LWJt/qxt9XzDDlOwwBbyL6g7BT1RmaAzuv NX8a+Z36zv/AjduDv/0Syc6kwkFy3n+cF32TW9aCeBTgR6A5n1FJ/7AjuMyjOLjwyiId sgtdRcHrgAyIW2k4MHFMlkNk6m1uyhDSca1IcyDMyO4XuDxIusz8IXFMYXFGVTA1UyTS pOHgH3yjXYCxWjqM6FURaYLhSsx7nWiYL6PHBPs1mAWfvQZoZjgKRMKqr9HNOoeGo1q3 5GbA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1744245465; x=1744850265; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=ZHrhc0OqrC98GB81DIBmeDu/0yj0Eidgx+ZJARRB9QU=; b=KHiodlkFF46hZ/1aotPMFwR5XotGSyiaXkpHQ4zbMNlPI9PNROqpFnFTc9tKapEJvS 6ZM+aYvWv0a1lJPsRBjj/dzeQaGagDXaa6bCYHukV+urNv1qnIXJ1mrY6DWBOJLrpk/8 2KPVjJ9n9J44VXcyjSUS4lzhBlYv5/VTTX8MBrU1MGhoH8TuSgXsmLm/rlPXt/UGlJuI KGR77OjaPoWpCFJTQphW9Tf4h7rvxprrMLWLlGK4ez3aryl4z6lmMbkhXuSwlPEq9c76 1i8K8rVNLmaOXz4k8NB3wB/iRMUxz2Q6US3jyBDr9aL70ZseBHsE+2x7EMdOoLU0Yo5k pPHw== X-Gm-Message-State: AOJu0Yye4nNpN7wYcuaXivmw5nvbbk64eqkMs/QM8Yvvw5UTHJI3RTXA +fgToqxP4ACnYbPP9YscmiTqnCT59orJEktxf5op+ie1heGfpROzx4AghlyxrN0Q3qbcESLGngh 1J/quvtepbL8vCltOYYQ3PNGTNT8= X-Gm-Gg: ASbGnctKMP8KHFz4Y7g+GyMPpuzjz6GjcZwFkrmsduhzaqhPF2V4OnAAqAH8BpAGgtU iaS2G1BhTkdMktss1Jvy0TYhw1MZ1rocpVqFvcrNUvDvyq2l+B3eW+PgKUy9D8cvynMrum1cJPI xCnIAJowfVd3dCgJYP9w4PMX8H X-Google-Smtp-Source: AGHT+IHVB+w9iaF2N9kaaNzRiD1o3bQQKNpnnt97YgjC1qCu5sToATdd3zWEoLxpHRm5H/0NEioI08TI34G0oGmidt0= X-Received: by 2002:a05:622a:1992:b0:476:8e3e:2da3 with SMTP id d75a77b69052e-4796cbc5b68mr14380811cf.30.1744245464627; Wed, 09 Apr 2025 17:37:44 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Robins Tharakan Date: Thu, 10 Apr 2025 10:07:06 +0930 X-Gm-Features: ATxdqUF2Cn4yVh71djhm6Oxi3NvbgwJaxMGu0DbO5O0hqfJwJEf-T_1LmrNV7UU Message-ID: Subject: Re: pgsql: Use extended stats for precise estimation of bucket size in hash To: Alexander Korotkov Cc: pgsql-committers@lists.postgresql.org Content-Type: multipart/alternative; boundary="00000000000051febe063261cbc5" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000051febe063261cbc5 Content-Type: text/plain; charset="UTF-8" Hi, On Mon, 10 Mar 2025 at 22:18, Alexander Korotkov wrote: > > Use extended stats for precise estimation of bucket size in hash join After this commit, I see a recurrence of an error similar to the one fixed in e28033fe1af8037e0fec8bb3a32fabbe18ac06b1 https://www.postgresql.org/message-id/18885-da51324078588253%40postgresql.org - robins https://robins.in --00000000000051febe063261cbc5 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi,

On Mon, 10 Mar 2025 at 22:18, = Alexander Korotkov <akorotkov@postgresql.org> wrote:
>
> Use ext= ended stats for precise estimation of bucket size in hash join


A= fter this commit, I see a recurrence of an error similar to the one fixed i= n e28033fe1af8037e0fec8bb3a32fabbe18ac06b1

--00000000000051febe063261cbc5--