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 1tjqdz-00DxcR-QJ for pgsql-committers@arkaria.postgresql.org; Mon, 17 Feb 2025 02:13:59 +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 1tjqdy-00CVSo-1Z for pgsql-committers@arkaria.postgresql.org; Mon, 17 Feb 2025 02:13:58 +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 1tjqdx-00CVSg-Nx for pgsql-committers@lists.postgresql.org; Mon, 17 Feb 2025 02:13:57 +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 1tjqdv-001Fz9-0j for pgsql-committers@lists.postgresql.org; Mon, 17 Feb 2025 02:13:57 +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=ZgfMkn5yUFjdxt2dr6gPukCwazef8X0Pk9e/n7lJ7Gg=; b=i+O29jjaVRjr+1ACfjaiV/Am/z F9O1Eas4I+AbDxjCdEGWB/uXilJASi6ld8pgcBUIfBTqlGV9BTzX10HflqdIwvHYDm6pUCB9mUy4z /T50AgbF0OXTCFlE//bREe/aeYgsrWGfzL6vanAwrGQW4FrvFgGGoH21rluVG+/hEmp0bQvPQtDTY 22o+SOFUmKZY5OU2Mu3RdrLMz+r8gpg29EWgR94DDV8lSEaiz3mOFgbCtETCqKCLJPymWQRbwg714 AUCP8kb8YmE85J1X0gst6yJQNunVff3wCMMpF+K7l2pDVnducxH90q41msEjZ6x64J7AxKA671YcC AxBrFe1w==; 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 1tjqdt-004vTu-5o for pgsql-committers@lists.postgresql.org; Mon, 17 Feb 2025 02:13:53 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tjqds-007X0r-4u for pgsql-committers@lists.postgresql.org; Mon, 17 Feb 2025 02:13:52 +0000 Content-Type: multipart/mixed; boundary="===============6689115003109823285==" MIME-Version: 1.0 From: Richard Guo To: pgsql-committers@lists.postgresql.org Subject: pgsql: Adjust tuples estimate for appendrels X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Mon, 17 Feb 2025 02:13:52 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============6689115003109823285== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 QWRqdXN0IHR1cGxlcyBlc3RpbWF0ZSBmb3IgYXBwZW5kcmVscwoKSW4gc2V0X2FwcGVuZF9yZWxf c2l6ZSgpLCB3ZSBjdXJyZW50bHkgc2V0IHJlbC0+dHVwbGVzIHRvIHJlbC0+cm93cwpmb3IgYW4g YXBwZW5kcmVsLiAgR2VuZXJhbGx5LCByZWwtPnR1cGxlcyBpcyB0aGUgcmF3IG51bWJlciBvZiB0 dXBsZXMKaW4gdGhlIHJlbGF0aW9uIGFuZCByZWwtPnJvd3MgaXMgdGhlIGVzdGltYXRlZCBudW1i ZXIgb2YgdHVwbGVzIGFmdGVyCnRoZSByZWxhdGlvbidzIHJlc3RyaWN0aW9uIGNsYXVzZXMgaGF2 ZSBiZWVuIGFwcGxpZWQuICBBbHRob3VnaCBhbgphcHBlbmRyZWwgaXRzZWxmIGRvZXNuJ3QgZGly ZWN0bHkgZW5mb3JjZSBhbnkgcXVhbHMgdG9kYXksIGl0cyBjaGlsZApyZWxhdGlvbnMgbWF5LiAg VGhlcmVmb3JlLCBzZXR0aW5nIHJlbC0+dHVwbGVzIGVxdWFsIHRvIHJlbC0+cm93cyBmb3IKYW4g YXBwZW5kcmVsIGlzbid0IGFsd2F5cyBhcHByb3ByaWF0ZS4KCkRvaW5nIHNvIGNhbiBsZWFkIHRv IGlzc3VlcyBpbiBjb3N0IGVzdGltYXRlcyBpbiBzb21lIGNhc2VzLiAgRm9yCmluc3RhbmNlLCB3 aGVuIGVzdGltYXRpbmcgdGhlIG51bWJlciBvZiBkaXN0aW5jdCB2YWx1ZXMgZnJvbSBhbgphcHBl bmRyZWwsIHdlIHdvdWxkIG5vdCBiZSBhYmxlIHRvIGFkanVzdCB0aGUgZXN0aW1hdGUgYmFzZWQg b24gdGhlCnJlc3RyaWN0aW9uIHNlbGVjdGl2aXR5LgoKVGhpcyBwYXRjaCBhZGRyZXNzZXMgdGhp cyBieSBzZXR0aW5nIGFuIGFwcGVuZHJlbCdzIHR1cGxlcyB0byB0aGUKdG90YWwgbnVtYmVyIG9m IHR1cGxlcyBhY2N1bXVsYXRlZCBmcm9tIGVhY2ggbGl2ZSBjaGlsZCwgd2hpY2ggYmV0dGVyCmFs aWducyB3aXRoIHJlYWxpdHkuCgpUaGlzIGlzIGFyZ3VhYmx5IGEgYnVnLCBidXQgbm9ib2R5IGhh cyBjb21wbGFpbmVkIGFib3V0IHRoYXQgdW50aWwKbm93LCBzbyBubyBiYWNrLXBhdGNoLgoKQXV0 aG9yOiBSaWNoYXJkIEd1byA8Z3VvZmVuZ2xpbnV4QGdtYWlsLmNvbT4KUmV2aWV3ZWQtYnk6IFRl bmRlciBXYW5nIDx0bmRyd2FuZ0BnbWFpbC5jb20+ClJldmlld2VkLWJ5OiBBbGVuYSBSeWJha2lu YSA8YS5yeWJha2luYUBwb3N0Z3Jlc3Byby5ydT4KRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3Iu ZXMvbS9DQU1iV3M0X1RHXytrVm42ZmpHLTVHWXp6dWtyTks1Nz1nOWVVbzRnc3JVRzI2T0Zhd2dA bWFpbC5nbWFpbC5jb20KCkJyYW5jaAotLS0tLS0KbWFzdGVyCgpEZXRhaWxzCi0tLS0tLS0KaHR0 cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi9mYmMwZmU5YTJlZmViNjE3MmY5 M2FkNzRhOTY1NmZkYWM1ZGUyNTA3CgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpzcmMv YmFja2VuZC9vcHRpbWl6ZXIvcGF0aC9hbGxwYXRocy5jIHwgMTkgKysrKysrKysrKysrKy0tLS0t LQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL2luaGVyaXQub3V0IHwgMzAgKysrKysrKysrKysr KysrKysrKysrKysrKysrKysrCnNyYy90ZXN0L3JlZ3Jlc3Mvc3FsL2luaGVyaXQuc3FsICAgICAg fCAyMSArKysrKysrKysrKysrKysrKysrKysKMyBmaWxlcyBjaGFuZ2VkLCA2NCBpbnNlcnRpb25z KCspLCA2IGRlbGV0aW9ucygtKQoK --===============6689115003109823285==--