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 1pRERP-0001xD-Gy for pgsql-bugs@arkaria.postgresql.org; Sun, 12 Feb 2023 15:38:59 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pRERO-0000gQ-Bj for pgsql-bugs@arkaria.postgresql.org; Sun, 12 Feb 2023 15:38:58 +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 1pR8wu-0002qP-Uh for pgsql-bugs@lists.postgresql.org; Sun, 12 Feb 2023 09:47:09 +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 1pR8wr-0004DX-Bu for pgsql-bugs@lists.postgresql.org; Sun, 12 Feb 2023 09:47:07 +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=LO5/MN7GMrvHrlGjMjZzzt1tzrbfNM1pE4zwcIlkbxI=; b=uY3LrhHEl092fI5/29Y74ih290 QwGt/pGTD5v2+4ENTewSXIF2UBDXp28ck/g1uF8K8Tq5Lec0EdUNFLSv+CtBNAhzG2z406ReDGoqz MtMiBn8wYl1OIrtfzjghH68V89hTP4sOmH+lLvjg367tfHYCnWfBmghbcwimxEhbavXrLY88naek2 Sji31RsYRe7kBlM038wNAww2JEt29ePvRXNCQjEzPj06lJHOti1Cxk4k3aP6O8A1MpasXM5ID7nlO XiaUrhoP/0Q64ekn7bA/sMkBqvDN/4sw7A8Kd4SBWPGpIIW5EYlrkhr8GSqPfVXdekCv28OfunvjG SLxEHCOw==; 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 1pR8wq-0006JE-6E for pgsql-bugs@lists.postgresql.org; Sun, 12 Feb 2023 09:47:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1pR8wp-002PKI-2R for pgsql-bugs@lists.postgresql.org; Sun, 12 Feb 2023 09:47:02 +0000 Content-Type: multipart/mixed; boundary="===============4415245639337454652==" MIME-Version: 1.0 Subject: BUG #17787: Seriously wrong value of pg_class.reltuples for FTS GIN index after VACUUM (INDEX_CLEANUP) 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: Sun, 12 Feb 2023 09:46:19 +0000 Message-ID: <17787-b2dbe62bdfabd467@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 --===============4415245639337454652== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzc4NwpMb2dnZWQgYnk6ICAgICAgICAgIE1heGltIEJvZ3VrCkVtYWls IGFkZHJlc3M6ICAgICAgbWF4aW0uYm9ndWtAZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lvbjog MTQuNQpPcGVyYXRpbmcgc3lzdGVtOiAgIFVidW50dQpEZXNjcmlwdGlvbjogICAgICAgIAoKSGks DQoNCk9uIG9uZSBvZiBwcm9kdWN0aW9uIHN5c3RlbSBvdXIgaW4taG91c2UgaW5kZXggYmxvYXQg bW9uaXRvcmluZyBzdGFydGVkCmJlaGF2ZSB3ZWlyZC4NCkFmdGVyIHNvbWUgcmVzZWFyY2ggSSBm b3VuZCB0aGF0IHRoZSB2YWx1ZSBvZiBwZ19jbGFzcy5yZWx0dXBsZXMgZm9yIEZUUyBHSU4KaW5k ZXggY291bGQgaGF2ZSB0d28gZGlmZmVyZW50IHZhbHVlcyB3aXRoIDIgb3JkZXIgbWFnbml0dWRl IGRpZmZlcmVuY2UKYmV0d2VlbiB0aGVtIGRlcGVuZHMgb2Ygd2hhdCBoYWQgYmVlbiBwZXJmb3Jt ZWQgbGFzdCBvbiB0aGUgdGFibGUKKGF1dG8pdmFjdXVtICh3aXRoIGluZGV4IGNsZWFudXApIG9y IChhdXRvKWFuYWx5emUuDQoNCk5vdyB3aGF0IEkgaGF2ZSBvbiBwcm9kdWN0aW9uOg0KYW5hbHl6 ZSB2ZXJib3NlICBwcm9jZXNzb3JfY2FsbGJhY2tzOw0KDQpzZWxlY3QgY291bnQoKikgZnJvbSBw cm9jZXNzb3JfY2FsbGJhY2tzOw0KICBjb3VudCAgIA0KLS0tLS0tLS0tLQ0KIDMzNDM5NTczDQoN CnNlbGVjdCByZWx0dXBsZXMgZnJvbSBwZ19jbGFzcyB3aGVyZSByZWxuYW1lPSdwYXlsb2FkX2lu ZGV4JzsNCiAgIHJlbHR1cGxlcyAgIA0KLS0tLS0tLS0tLS0tLS0tDQogMy4zNDU2MzQ0ZSswNw0K DQpTbyBmYXIgc2VlbXMgb2suLi4gbm93IGFmdGVyOg0KVkFDVVVNICh2ZXJib3NlLCBJTkRFWF9D TEVBTlVQIE9OKSAicHVibGljIi4icHJvY2Vzc29yX2NhbGxiYWNrcyI7DQp0aGUgZGF0YWJhc2Ug cHJvZHVjZToNCnNlbGVjdCByZWx0dXBsZXMgZnJvbSBwZ19jbGFzcyB3aGVyZSByZWxuYW1lPSdw YXlsb2FkX2luZGV4JzsNCiAgIHJlbHR1cGxlcyAgIA0KLS0tLS0tLS0tLS0tLS0tDQogMy41NTY1 ODA5ZSswOQ0KDQpBZnRlciBhbmFseXplIHZlcmJvc2UgIHByb2Nlc3Nvcl9jYWxsYmFja3M7IHZh bHVlIHJldHVybiB0byBvcmlnaW5hbAp2YWx1ZToNCmFuYWx5emUgcHJvY2Vzc29yX2NhbGxiYWNr czsNCnNlbGVjdCByZWx0dXBsZXMgZnJvbSBwZ19jbGFzcyB3aGVyZSByZWxuYW1lPSdwYXlsb2Fk X2luZGV4JzsNCiAgIHJlbHR1cGxlcyAgIA0KLS0tLS0tLS0tLS0tLS0tDQogMy4zNjIyNzI4ZSsw Nw0KDQoNCg0KRXZlcnkgdGltZSBJIHJ1biBhbmFseXplIG9uIHRoZSB0YWJsZSAtIEkgaGF2ZSAz LjNlKzA3IHJlbHR1cGVzIGZvciB0aGlzCmluZGV4LA0KZXZlcnkgdGltZSBJIHJ1biBWQUNVVU0g KElOREVYX0NMRUFOVVAgT04pIG9uIHRoZSB0YWJsZSAtIEkgaGF2ZSAzLjVlKzA5CnJlbHR1cGVz IGZvciB0aGlzIGluZGV4IChlLmcuIGlzc3VlIGFic29sdXRlbHkgcmVwZWF0YWJsZSkuDQoNClRo ZSB0YWJsZSAoYW5kIGluZGV4KSBzdHJ1Y3R1cmU6DQogXGQrICBwcm9jZXNzb3JfY2FsbGJhY2tz DQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgIFRhYmxlCiJwdWJsaWMucHJvY2Vzc29yX2NhbGxiYWNrcyINCiAgICAgQ29sdW1uICAg ICAgfCAgICAgICAgICAgIFR5cGUgICAgICAgICAgICAgfCBDb2xsYXRpb24gfCBOdWxsYWJsZSB8 ICAgICAKICAgICAgIERlZmF1bHQgICAgICAgICAgICAgIHwgU3RvcmFnZSAgfCBDb21wcmVzc2lv biB8IFN0YXRzIHRhcmdldCB8CkRlc2NyaXB0aW9uIA0KLS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0rLS0tLS0tLS0tLSstLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLSstLS0tLS0t LS0tLS0tLSstLS0tLS0tLS0tLS0tDQogaWQgICAgICAgICAgICAgIHwgaW50ZWdlciAgICAgICAg ICAgICAgICAgICAgIHwgICAgICAgICAgIHwgbm90IG51bGwgfApnZW5lcmF0ZWQgYnkgZGVmYXVs dCBhcyBpZGVudGl0eSB8IHBsYWluICAgIHwgICAgICAgICAgICAgfCAgICAgICAgICAgICAgfAoN Ci4uLg0KIHBheWxvYWQgICAgICAgICB8IGpzb24gICAgICAgICAgICAgICAgICAgICAgICB8ICAg ICAgICAgICB8IG5vdCBudWxsIHwgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgfCBl eHRlbmRlZCB8ICAgICAgICAgICAgIHwgICAgICAgICAgICAgIHwgDQpJbmRleGVzOg0KICAgICJw cm9jZXNzb3JfY2FsbGJhY2tzX3BrZXkiIFBSSU1BUlkgS0VZLCBidHJlZSAoaWQpDQogICAgInBh eWxvYWRfaW5kZXgiIGdpbiAodG9fdHN2ZWN0b3IoJ2VuZ2xpc2gnOjpyZWdjb25maWcsIHBheWxv YWQgLT4+CidwYXJhbXMnOjp0ZXh0KSkNCi4uLg0KDQoNCkkgdGhpbmsgZmlyc3QgdmFsdWUgYmV0 dGVyIHJlcHJlc2VudHMgcmVhbHR5LCBidXQgc2Vjb25kIG9uIGNvdWxkIGhhdmUgc2Vuc2UKYXMg d2VsbCAoZGVwZW5kIG9mIGhvdyB0byBkZWZpbmUgInR1cGVzIiBpbiBHSU4gaW5kZXggSSBzdXNw ZWN0KSwNCmhvd2V2ZXIgYm90aCBvZiB0aGVtIGNhbm5vdCBiZSBjb3JyZWN0IGluIHNhbWUgdGlt ZS4NCg0KDQpXaGlsZSB0ZXN0aW5nIG9uIHNtYWxsIHNhbXBsZSBvZiAxMDByb3dzIEkgd2Fzbid0 IGFibGUgdG8gcmVwcm9kdWNlIHRoYXQKYmVoYXZpb3IsIGJ1dCBpdCBlYXNpbHkgcmVwcm9kdWNp YmxlIHdpdGggdmFjdXVtIGZ1bGw6DQoNCmNyZWF0ZSB0YWJsZSAgdGVzdCBhcyBzZWxlY3QgcGF5 bG9hZCBmcm9tIHByb2Nlc3Nvcl9jYWxsYmFja3MgIG9yZGVyIGJ5IGlkIApkZXNjIGxpbWl0IDEw MDsNCmNyZWF0ZSBpbmRleCB0ZXN0X2dpbiBvbiB0ZXN0IFVTSU5HIEdJTiAodG9fdHN2ZWN0b3Io J2VuZ2xpc2gnOjpyZWdjb25maWcsCnBheWxvYWQgLT4+ICdwYXJhbXMnOjp0ZXh0KSk7DQphbmFs eXplIHRlc3Q7DQpzZWxlY3QgcmVsdHVwbGVzIGZyb20gcGdfY2xhc3Mgd2hlcmUgcmVsbmFtZT0n dGVzdF9naW4nOw0KIHJlbHR1cGxlcyANCi0tLS0tLS0tLS0tDQogICAgMTAwDQp2YWN1dW0gRlVM TCB0ZXN0Ow0Kc2VsZWN0IHJlbHR1cGxlcyBmcm9tIHBnX2NsYXNzIHdoZXJlIHJlbG5hbWU9J3Rl c3RfZ2luJzsNCiByZWx0dXBsZXMgDQotLS0tLS0tLS0tLQ0KICAgICAxNTgzNA0KYW5hbHl6ZSB0 ZXN0Ow0Kc2VsZWN0IHJlbHR1cGxlcyBmcm9tIHBnX2NsYXNzIHdoZXJlIHJlbG5hbWU9J3Rlc3Rf Z2luJzsNCiByZWx0dXBsZXMgDQotLS0tLS0tLS0tLQ0KICAgICAgIDEwMA0KQW5kIHNvIG9uLi4u DQoNCg0KUFM6DQpJIHN1c3BlY3QgdGhhdCB0aGUgaXNzdWUgY291bGQgYmUgcmVsYXRlZCB0byB0 aGUgZm9sbG93aW5nIGRpc2N1c3Npb246DQpodHRwczovL3d3dy5wb3N0Z3Jlc3FsLm9yZy9tZXNz YWdlLWlkL2ZsYXQvQ0FEMjFBb0FBNyUyQkVUVUpvJTNEajJMOEtBZEtGOFE5XzV1cXdOeDZIOHJ1 Y0ZtNmFSWlNCQSU0MG1haWwuZ21haWwuY29tIzJmMDYwNDNmMzk0YTgzNWM5OTNlYmYyM2EyYWYx MTgzDQoNCg0KS2luZCBSZWdhcmRzLA0KTWF4aW0KCg== --===============4415245639337454652==--