Re: BUG #13492: drop database does not release disk space

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: ismaelbezerra(at)gmail(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #13492: drop database does not release disk space
Date: 2015-07-07 20:35:26
Message-ID: 32284.1436301326@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

ismaelbezerra(at)gmail(dot)com writes:
> I'm having problem to drop a database. When performing the drop database
> command postgresql does not release the disk space. The directory with oid
> database remains on disk. This database has been updated from version 9.3.4
> to 9.4.4 with the -k option pg_upgrade. What can it be?

If you forgot to rm -rf the 9.3 database directory after you were finished
upgrading, then all those files are still hard-linked into the 9.3 tree,
so they wouldn't disappear after being dropped from the 9.4 tree.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message grb 2015-07-07 22:27:39 BUG #13493: pl/pgsql doesn't scale with cpus (PG9.3, 9.4)
Previous Message ismaelbezerra 2015-07-07 18:45:24 BUG #13492: drop database does not release disk space