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 1trbdH-0068qs-K2 for pgsql-committers@arkaria.postgresql.org; Mon, 10 Mar 2025 11:49:19 +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 1trbdG-00A77R-8Y for pgsql-committers@arkaria.postgresql.org; Mon, 10 Mar 2025 11:49:18 +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.94.2) (envelope-from ) id 1trbc1-00A4Kq-2M for pgsql-committers@lists.postgresql.org; Mon, 10 Mar 2025 11:48:01 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1trbbx-00223z-0l for pgsql-committers@lists.postgresql.org; Mon, 10 Mar 2025 11:48:00 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Date:Message-Id:Subject:To:From:MIME-Version: Content-Type:Sender:Reply-To:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=J3usTlhO8dxBOKquEi8YpJCFQSP8rm2POknlHh1bK3Y=; b=Q1g8gfsIX/4razaY5vWr0TnquB 7hAsts7UkUJJc2E9TK3Lf39omNdNWAfq8P9T6yBca7SL9IwnqR6Wcck8NzzKuhjeQV5n2WQ9IokbY 5Dz+dsVBXNBGWW8+EKFAsgliaMhWDYR4tWsNxvWNyO8CvZFXLxteFsDzuRnMSgeCXDnrXLaMsXNO9 JpkWu//uA1VBJS0EWirRq0bEu950WMtFrG7KWZmdFSw9eCkuW4Goz0t6QgvgdQ9lUFVoZ8Cw5pJ5u nz2/Efm4SaVqmqXtS1p5WF2RGO60nSEiR49m6ba2m1hij67MElkJyTv7mhRbTD5S2OJ/RFz0GM1dr 7HZlGOQw==; Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1trbbx-005GLx-3t for pgsql-committers@lists.postgresql.org; Mon, 10 Mar 2025 11:47:57 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1trbbw-001knB-1S for pgsql-committers@lists.postgresql.org; Mon, 10 Mar 2025 11:47:56 +0000 Content-Type: multipart/mixed; boundary="===============2093664806071200366==" MIME-Version: 1.0 From: Alexander Korotkov To: pgsql-committers@lists.postgresql.org Subject: pgsql: Use extended stats for precise estimation of bucket size in hash X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Mon, 10 Mar 2025 11:47:56 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============2093664806071200366== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VXNlIGV4dGVuZGVkIHN0YXRzIGZvciBwcmVjaXNlIGVzdGltYXRpb24gb2YgYnVja2V0IHNpemUg aW4gaGFzaCBqb2luCgpSZWNvZ25pemluZyB0aGUgcmVhbC1saWZlIGNvbXBsZXhpdHkgd2hlcmUg Y29sdW1ucyBpbiB0aGUgdGFibGUgb2Z0ZW4gaGF2ZQpmdW5jdGlvbmFsIGRlcGVuZGVuY2llcywg UG9zdGdyZVNRTCdzIGVzdGltYXRpb24gb2YgdGhlIG51bWJlciBvZiBkaXN0aW5jdAp2YWx1ZXMg b3ZlciBhIHNldCBvZiBjb2x1bW5zIGNhbiBiZSB1bmRlcmVzdGltYXRlZCAob3IgbXVjaCByYXJl bHksCm92ZXJlc3RpbWF0ZWQpIHdoZW4gZGVhbGluZyB3aXRoIG11bHRpLWNsYXVzZSBKT0lOLiAg SW4gdGhlIGNhc2Ugb2YgaGFzaApqb2luLCBpdCBjYW4gZW5kIHVwIHdpdGggYSBzbWFsbCBudW1i ZXIgb2YgcHJlZGljdGVkIGhhc2ggIGJ1Y2tldHMgYW5kLCBhcwphIHJlc3VsdCwgcGlja2luZyBu b24tb3B0aW1hbCBtZXJnZSBqb2luLgoKVG8gaW1wcm92ZSB0aGUgc2l0dWF0aW9uLCB3ZSBpbnRy b2R1Y2Ugb25lIGFkZGl0aW9uYWwgc3RhZ2Ugb2YgYnVja2V0IHNpemUKZXN0aW1hdGlvbiAtIGhh dmluZyB0d28gb3IgbW9yZSBqb2luIGNsYXVzZXMgZXN0aW1hdG9yIGxvb2t1cCBmb3IgZXh0ZW5k ZWQKc3RhdGlzdGljcyBhbmQgdXNlIGl0IGZvciBtdWx0aWNvbHVtbiBlc3RpbWF0aW9uLiAgQ2xh dXNlcyBhcmUgZ3JvdXBlZCBpbnRvCmxpc3RzLCBlYWNoIGNvbnRhaW5pbmcgZXhwcmVzc2lvbnMg cmVmZXJlbmNpbmcgdGhlIHNhbWUgcmVsYXRpb24uICBUaGUgcmVzdWx0Cm9mIHRoZSBtdWx0aWNv bHVtbiBlc3RpbWF0aW9uIG1hZGUgb3ZlciBzdWNoIGEgbGlzdCBpcyBjb21iaW5lZCB3aXRoIG90 aGVycwphY2NvcmRpbmcgdG8gdGhlIGNhbGxlcidzIGxvZ2ljLiAgQ2xhdXNlcyB0aGF0IGFyZSBu b3QgZXN0aW1hdGVkIGFyZSByZXR1cm5lZAp0byB0aGUgY2FsbGVyIGZvciBmdXJ0aGVyIGVzdGlt YXRpb24uCgpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9tLzUyMjU3NjA3LTU3ZjYtODUw ZC0zOTlhLWVjMzNhNjU0NDU3YiU0MHBvc3RncmVzcHJvLnJ1CkF1dGhvcjogQW5kcmVpIExlcGlr aG92IDxsZXBpaG92QGdtYWlsLmNvbT4KUmV2aWV3ZWQtYnk6IEFuZHkgRmFuIDx6aGlodWkuZmFu MTIxM0BnbWFpbC5jb20+ClJldmlld2VkLWJ5OiBUb21hcyBWb25kcmEgPHRvbWFzLnZvbmRyYUBl bnRlcnByaXNlZGIuY29tPgpSZXZpZXdlZC1ieTogQWxlbmEgUnliYWtpbmEgPGxlbmEucmliYWNr aW5hQHlhbmRleC5ydT4KUmV2aWV3ZWQtYnk6IEFsZXhhbmRlciBLb3JvdGtvdiA8YWVrb3JvdGtv dkBnbWFpbC5jb20+CgpCcmFuY2gKLS0tLS0tCm1hc3RlcgoKRGV0YWlscwotLS0tLS0tCmh0dHBz Oi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvNmJiNmE2MmYzY2M0NTYyNGM2MDFk NTI3MDY3M2ExNzQ0NzczNDYyOQoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0Kc3JjL2Jh Y2tlbmQvb3B0aW1pemVyL3BhdGgvY29zdHNpemUuYyAgIHwgIDEyICsrLQpzcmMvYmFja2VuZC91 dGlscy9hZHQvc2VsZnVuY3MuYyAgICAgICAgfCAxNzUgKysrKysrKysrKysrKysrKysrKysrKysr KysrKysrKysKc3JjL2luY2x1ZGUvdXRpbHMvc2VsZnVuY3MuaCAgICAgICAgICAgIHwgICA0ICsK c3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9zdGF0c19leHQub3V0IHwgIDQ1ICsrKysrKysrCnNy Yy90ZXN0L3JlZ3Jlc3Mvc3FsL3N0YXRzX2V4dC5zcWwgICAgICB8ICAyOSArKysrKysKNSBmaWxl cyBjaGFuZ2VkLCAyNjQgaW5zZXJ0aW9ucygrKSwgMSBkZWxldGlvbigtKQoK --===============2093664806071200366==--