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 1khdBc-0003eq-FG for pgsql-hackers@arkaria.postgresql.org; Tue, 24 Nov 2020 18:37:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1khdBb-0007X0-DW for pgsql-hackers@arkaria.postgresql.org; Tue, 24 Nov 2020 18:37:07 +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 1khdBb-0007Wt-2x for pgsql-hackers@lists.postgresql.org; Tue, 24 Nov 2020 18:37:07 +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 1khdBX-0003x8-Os for pgsql-hackers@lists.postgresql.org; Tue, 24 Nov 2020 18:37:06 +0000 Received: from coridan.postgresql.org ([2001:4800:3e1:1::213]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1khdBW-000422-Iq for pgsql-hackers@lists.postgresql.org; Tue, 24 Nov 2020 18:37:02 +0000 Received: from localhost ([127.0.0.1] helo=coridan.postgresql.org) by coridan.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1khdBW-0006aQ-1s for pgsql-hackers@lists.postgresql.org; Tue, 24 Nov 2020 18:37:02 +0000 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Subject: Re: BUG #16663: DROP INDEX did not free up disk space: idle connection hold file marked as deleted To: pgsql-hackers@lists.postgresql.org From: David Zhang Cc: Thomas Munro Date: Tue, 24 Nov 2020 18:36:33 +0000 User-Agent: pgcommitfest X-cfsender: david.z In-Reply-To: References: <16663-fe97ccf9932fc800@postgresql.org> Message-ID: <160624299337.7563.13562988821961887884.pgcf@coridan.postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk SSB2ZXJpZmllZCB0aGUgcGF0Y2ggInYyLTAwMDEtRnJlZS1kaXNrLXNwYWNlLWZvci1kcm9wcGVk LXJlbGF0aW9ucy1vbi1jb21taXQucGF0Y2giIG9uIG1hc3RlciBicmFuY2ggIjBjYzk5MzI3ODg4 ODQwZjJiZjU3MjMwM2I2ODQzOGU0Y2FmNjJkZTkiLiBJdCB3b3JrcyBmb3IgbWUuIEJlbG93IGlz IG15IHRlc3QgcHJvY2VkdXJlIGFuZCByZXN1bHRzLg0KDQo9PT0gQmVmb3JlIHRoZSBwYXRjaCA9 PT0NCiMxIGZyb20gcHNxbCBjb25zb2xlIDEsIGNyZWF0ZSB0YWJsZSBhbmQgaW5kZXggdGhlbiBp bnNlcnQgZW5vdWdoIGRhdGENCnBvc3RncmVzPSMgQ1JFQVRFIFRBQkxFIHRlc3RfdGJsICggYSBp bnQsIGIgdGV4dCk7DQpwb3N0Z3Jlcz0jIENSRUFURSBJTkRFWCBpZHhfdGVzdF90Ymwgb24gdGVz dF90YmwgKGEpOw0KcG9zdGdyZXM9IyBJTlNFUlQgSU5UTyB0ZXN0X3RibCBTRUxFQ1QgZ2VuZXJh dGVfc2VyaWVzKDEsODAwMDAwMDApLCdIZWxsbyB3b3JsZCEnOw0KcG9zdGdyZXM9IyBJTlNFUlQg SU5UTyB0ZXN0X3RibCBTRUxFQ1QgZ2VuZXJhdGVfc2VyaWVzKDEsODAwMDAwMDApLCdIZWxsbyB3 b3JsZCEnOw0KDQojMiBjaGVjayBmaWxlcyBzaXplIA0KZGF2aWQ6MTI4NjckIGR1IC1oDQoxMkcJ Lg0KDQojMyBmcm9tIHBzcWwgY29uc29sZSAyLCBkcm9wIHRoZSBpbmRleA0KcG9zdGdyZXM9IyBk cm9wIGluZGV4IGlkeF90ZXN0X3RibDsNCg0KIzQgY2hlY2sgZmlsZXMgc2l6ZSBpbiBkaWZmZXJl bnQgd2F5cywNCmRhdmlkOjEyODY3JCBkdSAtaA0KNy44RwkuDQpkYXZpZDoxMjg2NyQgbHMgLWwN Ci4uLg0KLXJ3LS0tLS0tLSAxIGRhdmlkIGRhdmlkICAgICAgICAgIDAgTm92IDIzIDIwOjA3IDE2 NDAyDQouLi4NCg0KJCBsc29mIC1uUCB8IGdyZXAgJyhkZWxldGVkKScgfGdyZXAgcGdkYXRhDQou Li4NCnBvc3RncmVzICAyNTczNiAgICAgICAgICAgICAgICAgIGRhdmlkICAgNDV1ICAgICAgUkVH ICAgICAgICAgICAgICAyNTksMiAgICAgICAgICAwICAgMTI1OTI3NTggL2hvbWUvZGF2aWQvc2Fu ZGJveC9wb3N0Z3Jlcy9wZ2RhdGEvYmFzZS8xMjg2Ny8xNjQwMiAoZGVsZXRlZCkNCnBvc3RncmVz ICAyNTczNiAgICAgICAgICAgICAgICAgIGRhdmlkICAgNDl1ICAgICAgUkVHICAgICAgICAgICAg ICAyNTksMiAxMDczNzQxODI0ICAgMTI1OTI3OTggL2hvbWUvZGF2aWQvc2FuZGJveC9wb3N0Z3Jl cy9wZ2RhdGEvYmFzZS8xMjg2Ny8xNjQwMi4xIChkZWxldGVkKQ0KcG9zdGdyZXMgIDI1NzM2ICAg ICAgICAgICAgICAgICAgZGF2aWQgICA1M3UgICAgICBSRUcgICAgICAgICAgICAgIDI1OSwyIDEw NzM3NDE4MjQgICAxMjU5MjczOSAvaG9tZS9kYXZpZC9zYW5kYm94L3Bvc3RncmVzL3BnZGF0YS9i YXNlLzEyODY3LzE2NDAyLjIgKGRlbGV0ZWQpDQpwb3N0Z3JlcyAgMjU3MzYgICAgICAgICAgICAg ICAgICBkYXZpZCAgIDU5dSAgICAgIFJFRyAgICAgICAgICAgICAgMjU5LDIgIDM3MjYwNDkyOCAg IDEyNTkyODAwIC9ob21lL2RhdmlkL3NhbmRib3gvcG9zdGdyZXMvcGdkYXRhL2Jhc2UvMTI4Njcv MTY0MDIuMyAoZGVsZXRlZCkNCi4uLg0KDQpUaGUgaW5kZXggcmVsbm9kZSBpZCAiMTY0MDIiIGRp c3BsYXlzIHNpemUgIjAiIGZyb20gcG9zdGdyZXMgZGF0YWJhc2UgZm9sZGVyLCBidXQgd2hlbiB1 c2luZyBsc29mIHRvIGNoZWNrLCBhbGwgMTY0MDIueCBhcmUgc3RpbGwgaW4gdXNlZCBieSBhIHBz cWwgY29ubmVjdGlvbiBleGNlcHQgMTY0MDIgaXMgc2V0IHRvIDAuIENoZWNrIGl0IGFnYWluIGFm dGVyIGFuIGhvdXIsIGxzb2Ygc2hvd3MgdGhlIHNhbWUgcmVzdWx0cy4NCg0KPT09IEFmdGVyIHRo ZSBwYXRjaCA9PT0NClJlcGVhdCBzdGVwIDEgfiA0LCBsc29mIHNob3dzIGFsbCB0aGUgaW5kZXgg cmVsbm9kZSBmaWxlcyAoaW4gdGhpcyBjYXNlLCB0aGUgaW5kZXggcmVsbm9kZSBpZCAxNjM4OSkg YXJlIHJlbW92ZWQgd2l0aGluIGFib3V0IDEgbWludXRlLg0KJCBsc29mIC1uUCB8IGdyZXAgJyhk ZWxldGVkKScgfGdyZXAgcGdkYXRhDQouLi4NCnBvc3RncmVzICAzMjcwNyAgICAgICAgICAgICAg ICAgIGRhdmlkICAgNjZ1ICAgICAgUkVHICAgICAgICAgICAgICAyNTksMiAgICAgICAgICAwICAg MTI1OTI3NjMgL2hvbWUvZGF2aWQvc2FuZGJveC9wb3N0Z3Jlcy9wZ2RhdGEvYmFzZS8xMjg2Ny8x NjM4OS4xIChkZWxldGVkKQ0KcG9zdGdyZXMgIDMyNzA3ICAgICAgICAgICAgICAgICAgZGF2aWQg ICA3MHUgICAgICBSRUcgICAgICAgICAgICAgIDI1OSwyICAgICAgICAgIDAgICAxMjU5MjgyMyAv aG9tZS9kYXZpZC9zYW5kYm94L3Bvc3RncmVzL3BnZGF0YS9iYXNlLzEyODY3LzE2Mzg5LjIgKGRl bGV0ZWQpDQpwb3N0Z3JlcyAgMzI3MDcgICAgICAgICAgICAgICAgICBkYXZpZCAgIDc0dSAgICAg IFJFRyAgICAgICAgICAgICAgMjU5LDIgICAgICAgICAgMCAgIDEyNTkyODA1IC9ob21lL2Rhdmlk L3NhbmRib3gvcG9zdGdyZXMvcGdkYXRhL2Jhc2UvMTI4NjcvMTYzODkuMyAoZGVsZXRlZCkNCi4u Lg0KDQpPbmUgdGhpbmcgaW50ZXJlc3RpbmcgZm9yIG1lIGlzIHRoYXQsIGlmIHRoZSBpbmRleCBp cyBjcmVhdGVkIGFmdGVyIGRhdGEgcmVjb3JkcyBoYXMgYmVlbiBpbnNlcnRlZCwgdGhlbiBsc29m IGRvZXNuJ3Qgc2hvdyB0aGlzIGlzc3VlLg==