Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oP4qR-0006F6-Uq for pgsql-committers@arkaria.postgresql.org; Fri, 19 Aug 2022 16:27:39 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oP4qQ-0000wy-N3 for pgsql-committers@arkaria.postgresql.org; Fri, 19 Aug 2022 16:27:38 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oP4qQ-0000wI-GM for pgsql-committers@lists.postgresql.org; Fri, 19 Aug 2022 16:27:38 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oP4qJ-0004bY-NC for pgsql-committers@lists.postgresql.org; Fri, 19 Aug 2022 16:27:37 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oP4qJ-0005RK-5U for pgsql-committers@lists.postgresql.org; Fri, 19 Aug 2022 16:27:31 +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 1oP4qG-000HhA-Nl for pgsql-committers@lists.postgresql.org; Fri, 19 Aug 2022 16:27:29 +0000 Content-Type: multipart/mixed; boundary="===============7063012229445197937==" MIME-Version: 1.0 From: Peter Geoghegan To: pgsql-committers@lists.postgresql.org Subject: pgsql: Avoid reltuples distortion in very small tables. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Fri, 19 Aug 2022 16:27:29 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============7063012229445197937== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 QXZvaWQgcmVsdHVwbGVzIGRpc3RvcnRpb24gaW4gdmVyeSBzbWFsbCB0YWJsZXMuCgpDb25zaXN0 ZW50bHkgYXZvaWQgdHJ1c3RpbmcgYSBzYW1wbGUgb2Ygb25seSBvbmUgcGFnZSBhdCB0aGUgcG9p bnQgdGhhdApWQUNVVU0gZGV0ZXJtaW5lcyBhIG5ldyByZWx0dXBsZXMgZm9yIHRoZSB0YXJnZXQg dGFibGUgKHRob3VnaCBvbmx5IHdoZW4KdGhlIHRhYmxlIGlzIGxhcmdlciB0aGFuIGEgc2luZ2xl IHBhZ2UpLiAgVGhpcyBpcyBmb2xsb3ctdXAgd29yayB0bwpjb21taXQgNzQzODhhMWEsIHdoaWNo IGFkZGVkIGEgaGV1cmlzdGljIHRvIHByZXZlbnQgcmVsdHVwbGVzIGZyb20KYmVjb21pbmcgZGlz dG9ydGVkIGJ5IHN1Y2Nlc3NpdmUgVkFDVVVNIG9wZXJhdGlvbnMgdGhhdCBlYWNoIHNjYW4gb25s eSBhCnNpbmdsZSBoZWFwIHBhZ2UgKHdoaWNoIHdhcyBpdHNlbGYgbW9yZSBvciBsZXNzIGEgYnVn Zml4IGZvciBhbiBpc3N1ZSBpbgpjb21taXQgNDRmYTg0ODgsIHdoaWNoIHNpbXBsaWZpZWQgVkFD VVVNJ3MgaGFuZGxpbmcgb2Ygc2Nhbm5lZCBwYWdlcykuCgpUaGUgb3JpZ2luYWwgYnVnZml4IGNv bW1pdCBkaWQgbm90IGFjY291bnQgZm9yIGNlcnRhaW4gcmVtYWluaW5nIGNhc2VzCnRoYXQgd2hl cmUgbm90IGFmZmVjdGVkIGJ5IGl0cyAiMiUgb2YgdG90YWwgcmVscGFnZXMiIGhldXJpc3RpYy4g IFRoaXMKaGFwcGVuZWQgd2l0aCByZWxhdGlvbnMgdGhhdCBhcmUgc21hbGwgZW5vdWdoIHRoYXQg anVzdCBvbmUgb2YgaXRzIHBhZ2VzCmV4Y2VlZGVkIHRoZSAyJSB0aHJlc2hvbGQsIHlldCBzdGls bCBiaWcgZW5vdWdoIGZvciBWQUNVVU0gdG8gZGVlbQpza2lwcGluZyBtb3N0IG9mIGl0cyBwYWdl cyB2aWEgdGhlIHZpc2liaWxpdHkgbWFwIHdvcnRod2hpbGUuICByZWx0dXBsZXMKY291bGQgc3Rp bGwgYmVjb21lIGRpc3RvcnRlZCBvdmVyIHRpbWUgd2l0aCBzdWNoIGEgdGFibGUsIGF0IGxlYXN0 IGluCnNjZW5hcmlvcyB3aGVyZSB0aGUgVkFDVVVNIGNvbW1hbmQgaXMgcnVuIHJlcGVhdGVkbHkg YW5kIHdpdGhvdXQgdGhlCnRhYmxlIGl0c2VsZiBldmVyIGNoYW5naW5nLgoKQXV0aG9yOiBQZXRl ciBHZW9naGVnYW4gPHBnQGJvd3QuaWU+CkRpc2N1c3Npb246IGh0dHBzOi8vcG9zdGdyLmVzL20v Q0FIMi1Xems3ZDRtM29FYkVXa1dRS2QrZ3otZURfcGVCdmRYVmsxYV9LQnlnWGFkRmVnQG1haWwu Z21haWwuY29tCkJhY2twYXRjaDogMTUtLCB3aGVyZSB0aGUgcnVsZXMgZm9yIHNjYW5uZWQgcGFn ZXMgY2hhbmdlZC4KCkJyYW5jaAotLS0tLS0KbWFzdGVyCgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6 Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi8zMDk3YmRlN2RkMWQ5ZTdiMTEyN2Iy NDkzNWU3MGNhNDYwOWUyMmIyCgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpzcmMvYmFj a2VuZC9jb21tYW5kcy92YWN1dW0uYyB8IDI2ICsrKysrKysrKystLS0tLS0tLS0tLS0tLS0tCjEg ZmlsZSBjaGFuZ2VkLCAxMCBpbnNlcnRpb25zKCspLCAxNiBkZWxldGlvbnMoLSkKCg== --===============7063012229445197937==--