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 1u2nCg-0061o4-M2 for pgsql-committers@arkaria.postgresql.org; Thu, 10 Apr 2025 08:24:06 +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 1u2nCf-009mls-1r for pgsql-committers@arkaria.postgresql.org; Thu, 10 Apr 2025 08:24:05 +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 1u2nCe-009mlg-LD for pgsql-committers@lists.postgresql.org; Thu, 10 Apr 2025 08:24:04 +0000 Received: from mail-ed1-x530.google.com ([2a00:1450:4864:20::530]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1u2nCc-0041Ya-23 for pgsql-committers@lists.postgresql.org; Thu, 10 Apr 2025 08:24:04 +0000 Received: by mail-ed1-x530.google.com with SMTP id 4fb4d7f45d1cf-5e5deb6482cso3085989a12.1 for ; Thu, 10 Apr 2025 01:24:02 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1744273440; x=1744878240; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=NjT6B3yME7WPGpoQfN8+WMkV2eUhC1FfF5Q1zJ7+Tu8=; b=hh/Nsxq42dEC7C63D1do1cTfzuEBodZpvJTU9SAHtzsrYBV7JhoM2hYzNiMiWwZC/J +nRS9Td2Eukn2UVPUa2yl6sFicApHJF5BUbMeMT7A/eVk2gtQFtdPwbYn+fWLyYYGkn/ blmWIjCo5eZv8e4MQ6At3/4fCPgxIbGBmYk4+y06mfcTN5bqq0Vqxd1MiXC4lkN9jmi3 RekCAiZaV9wDjwlbn9BCGLUx1n4Mx4mC3J4JyXt836a4kpKRkfHy3UNwbsbdEowf5uDq 6/+c5DDGw6SlzP5sCKeSvoR3SdzpIfF8U7XO6RyplX7wdYvRcafj7JwBJCSd9PnbOCT3 9pmA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1744273440; x=1744878240; h=content-transfer-encoding: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=NjT6B3yME7WPGpoQfN8+WMkV2eUhC1FfF5Q1zJ7+Tu8=; b=ASqwhgNjYFw7ovB1RJRNFa9a35sNLj4PK8RlVaj2ViAiciNyj1hhF2HDFxIftfkXmU jxdtyljlxj1DGhMoverVPRRcFShirwI8Ydaljge9G/IDqVrlvRSFGN6hlPx7QrAX8V9C QqGGYBEtV14otV5fJFarfbSv8HJc5vml+Slg3uRcwXDZYYfBiEj9yMET7CH/BJE2okIU 9XLcV1r8zm+pzO/Gx5Xin96aStUv24huTQaxkkERWytZCrUblb4WUQiSHg3XHERBByjy pc87/qPBeGdKWGDw75IXCDGGXDQK24trwyFza15JplqAemG+XohA9PTUAEU3GaWEYj8b C5vg== X-Forwarded-Encrypted: i=1; AJvYcCXTWEjXRKU9OQ65QKQmbcQ4APjsI8UV0MjAJ5eAnJAqr1A/feBqlbZhWqxASVzIoMimdpEShasmXV5i28JF/0pF@lists.postgresql.org X-Gm-Message-State: AOJu0Yy9qI30EZhJIqWYWk+j9TwSQqMVh85elTiyegoy202HnK5HiDVJ iJL2m2z7im5yKp93tZ/VSB8RBSL3BwE7hpQ3E5ODSkPLZ8k9714tz2I/b3UPo03inTdUvEwET/3 /ja9TvLLDlUYI4I6R4KC72Dp+/s8= X-Gm-Gg: ASbGncvB2U7am07Zakr8sPbTXIQixouLbW3hHlrhpiMepTrpwTTyxycBTqYRU709S5g lixK5rP706bMap3Twe/NyZLhF7G75Yt2jukVk5rqFRD/IK1k6ZqktwOQbf57mQuU2D7yJuqmKd+ 15Q/n/ELO3KBEtqMzbvOkKAg== X-Google-Smtp-Source: AGHT+IEE2L6m76xn4oYgDdSleEvUvvk4ov2vyjwHLLxGoWK9RI+su27WDrlC6Yrs0wnZj/BLp3zflTWONwWyO5dsQt4= X-Received: by 2002:a05:6402:40d4:b0:5ec:cb95:c3ce with SMTP id 4fb4d7f45d1cf-5f32a4e31d6mr1862563a12.1.1744273439952; Thu, 10 Apr 2025 01:23:59 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Alexander Korotkov Date: Thu, 10 Apr 2025 11:23:48 +0300 X-Gm-Features: ATxdqUFNbtPfcXof4Yxmk_0XpQMJTGeZ2xXMhLan94m8mqdKrn7JmuFymgtZWU8 Message-ID: Subject: Re: pgsql: Use extended stats for precise estimation of bucket size in hash To: Robins Tharakan Cc: Alexander Korotkov , pgsql-committers@lists.postgresql.org Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, Apr 10, 2025 at 3:37=E2=80=AFAM Robins Tharakan wrote: > 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 fixe= d in e28033fe1af8037e0fec8bb3a32fabbe18ac06b1 > > https://www.postgresql.org/message-id/18885-da51324078588253%40postgresql= .org Thank you, I'm looking into that. ------ Regards, Alexander Korotkov Supabase