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 1mWNld-0008CC-8r for pgsql-committers@arkaria.postgresql.org; Fri, 01 Oct 2021 19:00:21 +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-0008BQ-Fn for pgsql-committers@arkaria.postgresql.org; Fri, 01 Oct 2021 19:00:17 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mWNlY-0007s1-Vo for pgsql-committers@lists.postgresql.org; Fri, 01 Oct 2021 19:00:17 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mWNlS-0002Jv-3m for pgsql-committers@lists.postgresql.org; Fri, 01 Oct 2021 19:00:16 +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 1mWNlP-0007bv-QY for pgsql-committers@lists.postgresql.org; Fri, 01 Oct 2021 19:00:07 +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-0007wh-20 for pgsql-committers@lists.postgresql.org; Fri, 01 Oct 2021 19:00:07 +0000 Content-Type: multipart/mixed; boundary="===============1469858621237299205==" 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 --===============1469858621237299205== 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 c3RncmVzcWwub3JnCgpCcmFuY2gKLS0tLS0tCm1hc3RlcgoKRGV0YWlscwotLS0tLS0tCmh0dHBz Oi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvOGMxMTQ0YmE3MzQ3OGI4MThkOWNl YmU4ZWNkNjRhMTRiN2Q0NWJkZQoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0Kc3JjL2Jh Y2tlbmQvdXRpbHMvYWR0L3NlbGZ1bmNzLmMgfCAzMCArKysrKysrKysrKysrKysrKysrKysrKysr LS0tLS0KMSBmaWxlIGNoYW5nZWQsIDI1IGluc2VydGlvbnMoKyksIDUgZGVsZXRpb25zKC0pCgo= --===============1469858621237299205==--