From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: denis.patron@previnet.it
Subject: BUG #16663: DROP INDEX did not free up disk space: idle connection hold file marked as deleted
Date: Fri, 09 Oct 2020 13:24:15 +0000
Message-ID: <16663-fe97ccf9932fc800@postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 16663
Logged by: Denis Patron
Email address: denis.patron@previnet.it
PostgreSQL version: 11.9
Operating system: CentOS 7
Description:
I have an index, which at the file system level, is made up of multiple
segments (file: <id>.1, <id>.2 ecc). When I DROP INDEX, the index is dropped
in Postgresql but at the file system level, the segments are marked as
"deleted". if I check with the lsof command, I see that the segments are in
use from an idle connection. This does not happen if the index is formed by
only one segment (in my case <1Gb). How can I prevent this?
thanks
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, denis.patron@previnet.it
Subject: Re: BUG #16663: DROP INDEX did not free up disk space: idle connection hold file marked as deleted
In-Reply-To: <16663-fe97ccf9932fc800@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox