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 1mVqzV-0000vb-1a for pgsql-bugs@arkaria.postgresql.org; Thu, 30 Sep 2021 08:00:29 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mVqzQ-0004hK-NW for pgsql-bugs@arkaria.postgresql.org; Thu, 30 Sep 2021 08:00:24 +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 1mVqMY-0002HA-Ub for pgsql-bugs@lists.postgresql.org; Thu, 30 Sep 2021 07:20:15 +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 1mVqMR-00028I-JA for pgsql-bugs@lists.postgresql.org; Thu, 30 Sep 2021 07:20:13 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=j1/u83ssEUA7vykR1G26h8JD6e1HqtfaKRcI/x0ql1A=; b=V510W+o6ooqrgWecHhqiQzC87w e2Y0OJUJ6LjkZjXdvU22wwt7CrXvTfT1N3pLuw1jYZ8PAW89dloPg4/WPtrOSnPZZfR5vglBjPaRF heGfMERzsWhyvyMTBhoON2YrCa03HA6GXwlpnQN0Ez/fGebYmpivxw/MIm00zf6trAi6v1su/M+55 oSodgvJINBsaDqmWKZrsj0p+UHnX1nVM8vLA4QVcHDsWerWZADIRrNAhYcvQeVivq5LqH+HDB+LUD p0JvOWcbqBYdQuQHplGPjq5vJ19fRGcBXFqeJ2HndRno+ujyWZrK4o2zKpYJOg7cqCP2UTupsNcWw RD1eoSYg==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mVqMQ-0007Um-6C for pgsql-bugs@lists.postgresql.org; Thu, 30 Sep 2021 07:20:06 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mVqMM-0006eu-GL for pgsql-bugs@lists.postgresql.org; Thu, 30 Sep 2021 07:20:02 +0000 Content-Type: multipart/mixed; boundary="===============4123077298162346331==" MIME-Version: 1.0 Subject: BUG #17205: pg_class.reltuples vakue wrong for brin indexes after vacuum (by many orders of magnitude) To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: maxim.boguk@gmail.com Reply-To: maxim.boguk@gmail.com, pgsql-bugs@lists.postgresql.org Date: Thu, 30 Sep 2021 07:19:53 +0000 Message-ID: <17205-42b1d8f131f0cf97@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============4123077298162346331== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzIwNQpMb2dnZWQgYnk6ICAgICAgICAgIE1heGltIEJvZ3VrCkVtYWls IGFkZHJlc3M6ICAgICAgbWF4aW0uYm9ndWtAZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lvbjog MTMuNApPcGVyYXRpbmcgc3lzdGVtOiAgIExpbnV4CkRlc2NyaXB0aW9uOiAgICAgICAgCgpIaSwN Cg0KcGdfY2xhc3MucmVsdHVwbGVzIHdyb25nIGJ5IG1hbnkgb3JkZXIgb2YgbWFnbml0dWRlIGFm dGVyIChhdXRvKXZhY3V1bSB0YWJsZQpmb3IgYnJpbiBpbmRleGVzLg0KQW5hbHl6ZSB0YWJsZSBz ZXQgY29ycmVudCB2YWx1ZSBiYWNrLCBhbmQgZm9sbG93aW5nIHZhY3V1bSBzZXQgaXQgd3JvbmcK YWdhaW4gKHNvIGNvcnJlY3RuZXNzIG9mIHZhbHVlIGluIHByb2R1Y3Rpb24gZGIgZGVwZW5kIG9u IGV4YWN0IHNlcXVlbmNlIG9mCmF1dG92YWN1dS9hdXRvYW5hbHl6ZSBydW5zKS4NCg0KVGVzdCBj YXNlOg0KDQptYm9ndWs9IyBjcmVhdGUgdGFibGUgdCAoaWQgaW50ZWdlcik7DQpDUkVBVEUgVEFC TEUNCm1ib2d1az0jIGluc2VydCBpbnRvIHQgc2VsZWN0IGlkIGZyb20gZ2VuZXJhdGVfc2VyaWVz KDEsIDEwMDAwMDAwKTsNCg0KbWJvZ3VrPSMgaW5zZXJ0IGludG8gdCBzZWxlY3QgaWQgZnJvbSBn ZW5lcmF0ZV9zZXJpZXMoMSwgMTAwMDAwMDApIGFzCmcoaWQpOw0KSU5TRVJUIDAgMTAwMDAwMDAN Cg0KbWJvZ3VrPSMgY3JlYXRlIGluZGV4IHRfYnJpbiBvbiB0IHVzaW5nIEJSSU4oaWQpOw0KQ1JF QVRFIElOREVYDQoNCm1ib2d1az0jIHZhY3V1bSBBTkFMWVpFIHQ7DQpWQUNVVU0NCg0KbWJvZ3Vr PSMgc2VsZWN0IHJlbHR1cGxlcyBmcm9tIHBnX2NsYXNzIHdoZXJlIHJlbG5hbWU9J3RfYnJpbic7 DQogIHJlbHR1cGxlcyAgIA0KLS0tLS0tLS0tLS0tLS0NCiA5Ljk5OTk3N2UrMDYNCigxIHJvdykN Cg0KbWJvZ3VrPSMgdmFjdXVtIHQ7DQpWQUNVVU0NCm1ib2d1az0jIHNlbGVjdCByZWx0dXBsZXMg ZnJvbSBwZ19jbGFzcyB3aGVyZSByZWxuYW1lPSd0X2JyaW4nOw0KIHJlbHR1cGxlcyANCi0tLS0t LS0tLS0tDQogICAgICAgMzQ1DQooMSByb3cpDQoNCm1ib2d1az0jIGFuYWx5emUgdDsNCkFOQUxZ WkUNCm1ib2d1az0jIHNlbGVjdCByZWx0dXBsZXMgZnJvbSBwZ19jbGFzcyB3aGVyZSByZWxuYW1l PSd0X2JyaW4nOw0KICByZWx0dXBsZXMgICANCi0tLS0tLS0tLS0tLS0tDQogOS45OTk5NzdlKzA2 DQooMSByb3cpDQoNCm1ib2d1az0jIHZhY3V1bSB0Ow0KVkFDVVVNDQptYm9ndWs9IyBzZWxlY3Qg cmVsdHVwbGVzIGZyb20gcGdfY2xhc3Mgd2hlcmUgcmVsbmFtZT0ndF9icmluJzsNCiByZWx0dXBs ZXMgDQotLS0tLS0tLS0tLQ0KICAgICAgIDM0NQ0KKDEgcm93KQ0KQW5kIHNvIG9uLi4uDQoNClRl c3RlZCBvbiAxMi4qIGFuZCAxMy4qIHZlcnNpb25zLg0KDQpLaW5kIFJlZ2FyZHMsDQpNYWtzeW0K Cg== --===============4123077298162346331==--