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 1mWNla-0008CB-Fo for pgsql-committers@arkaria.postgresql.org; Fri, 01 Oct 2021 19:00:18 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mWNlZ-0008BM-Fc for pgsql-committers@arkaria.postgresql.org; Fri, 01 Oct 2021 19:00:17 +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 1mWNlU-0006BQ-W5 for pgsql-committers@lists.postgresql.org; Fri, 01 Oct 2021 19:00:12 +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 1mWNlQ-0002MN-Sn for pgsql-committers@lists.postgresql.org; Fri, 01 Oct 2021 19:00:11 +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 1mWNlQ-0007c0-04 for pgsql-committers@lists.postgresql.org; Fri, 01 Oct 2021 19:00:08 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mWNlP-0007wr-3e for pgsql-committers@lists.postgresql.org; Fri, 01 Oct 2021 19:00:07 +0000 Content-Type: multipart/mixed; boundary="===============1501126005079875657==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Avoid believing incomplete MCV-only stats in get_variable_range( X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Fri, 01 Oct 2021 19:00:07 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============1501126005079875657== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 QXZvaWQgYmVsaWV2aW5nIGluY29tcGxldGUgTUNWLW9ubHkgc3RhdHMgaW4gZ2V0X3ZhcmlhYmxl X3JhbmdlKCkuCgpnZXRfdmFyaWFibGVfcmFuZ2UoKSB3b3VsZCBpbmNhdXRpb3VzbHkgYmVsaWV2 ZSB0aGF0IHN0YXRpc3RpY3MKY29udGFpbmluZyBvbmx5IGFuIE1DViBsaXN0IGFyZSBzdWZmaWNp ZW50IHRvIGRlcml2ZSBhIHJhbmdlIGVzdGltYXRlLgpUaGF0J3Mgb2theSBmb3IgYW4gZW51bS1s aWtlIGNvbHVtbiB0aGF0IGNvbnRhaW5zIG9ubHkgTUNWcywgYnV0Cm90aGVyd2lzZSB0aGUgZXN0 aW1hdGUgY291bGQgYmUgcHJldHR5IGJhZC4gIE1ha2UgaXQgcmVwb3J0IHRoYXQgdGhlCnJhbmdl IGlzIGluZGV0ZXJtaW5hdGUgdW5sZXNzIHRoZSBNQ1ZzIHBsdXMgbnVsbGZyYWMgYWNjb3VudCBm b3IKdGhlIHdob2xlIHRhYmxlLgoKSSBkb24ndCB0aGluayB0aGlzIG5lZWRzIGEgZGVkaWNhdGVk IHRlc3QgY2FzZSwgc2luY2UgYSBxdWljayBjb2RlCmNvdmVyYWdlIGNoZWNrIHZlcmlmaWVzIHRo YXQgdGhlIGV4aXN0aW5nIHJlZ3Jlc3Npb24gdGVzdHMgdHJhdmVyc2UKYWxsIHRoZSBhbHRlcm5h dGl2ZXMuICBUaGVyZSBpcyByb29tIHRvIGRvdWJ0IHRoYXQgYSBmdXR1cmUtcHJvb2YKdGVzdCBj YXNlIGNvdWxkIGJlIGJ1aWx0IGFueXdheSwgZ2l2ZW4gdGhhdCB0aGUgc3VibWl0dGVkIGV4YW1w bGUKYWNjaWRlbnRhbGx5IGRvZXNuJ3QgZmFpbCBiZWZvcmUgdjExLgoKUGVyIGJ1ZyAjMTcyMDcg ZnJvbSBTaW1vbiBQZXJlcGVsaXRzYS4gIEJhY2stcGF0Y2ggdG8gdjEwLgpJbiBwcmluY2lwbGUg dGhpcyBoYXMgYmVlbiBicm9rZW4gYWxsIGFsb25nLCBidXQgSSdtIGhlc2l0YW50IHRvCm1ha2Ug c3VjaCBjaGFuZ2VzIGluIDkuNiwgc2luY2UgaWYgYW55b25lIGlzIHVuaGFwcHkgd2l0aCA5LjYu MjQncwpiZWhhdmlvciB0aGVyZSB3aWxsIGJlIG5vIHNlY29uZCBjaGFuY2UgdG8gZml4IGl0LgoK RGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS8xNzIwNy01MjY1YWVmYTc5ZTMzM2I0QHBv c3RncmVzcWwub3JnCgpCcmFuY2gKLS0tLS0tClJFTF8xMV9TVEFCTEUKCkRldGFpbHMKLS0tLS0t LQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmLzU4NjNkMzQ4YTIyZjli OWUwMTRjZmNkMzZhNzA1MjM4YjA3OGIyNTMKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0t CnNyYy9iYWNrZW5kL3V0aWxzL2FkdC9zZWxmdW5jcy5jIHwgODYgKysrKysrKysrKysrKysrKysr KysrKysrKystLS0tLS0tLS0tLS0tLQoxIGZpbGUgY2hhbmdlZCwgNTYgaW5zZXJ0aW9ucygrKSwg MzAgZGVsZXRpb25zKC0pCgo= --===============1501126005079875657==--