Re: BUG #15582: ALTER TABLE/INDEX ... SET TABLESPACE does not freedisk space - Mailing list pgsql-bugs

From AP
Subject Re: BUG #15582: ALTER TABLE/INDEX ... SET TABLESPACE does not freedisk space
Date
Msg-id 20190110104053.hxurczmhhuzvopxk@zip.com.au
Whole thread Raw
In response to Re: BUG #15582: ALTER TABLE/INDEX ... SET TABLESPACE does not free disk space  (Sergei Kornilov <sk@zsrv.org>)
List pgsql-bugs
On Thu, Jan 10, 2019 at 12:44:58PM +0300, Sergei Kornilov wrote:
> Hi
> If archiver can not save WAL - postgresql will not remove these WAL and pg_wal directory will grow unlimited. And i
thinkyour alter table set tablespace works ok and table was removed from original disk. But was fully copied to WAL and
suchWAL can not be deleted, therefore overall disk space usage is same. So you need repair you archive_command first.
 

Hi,

I just checked. There are only 16GB of WAL in pg_wal. I moved
5.5TB of data so I don't think that that is it.

There are also no errors when I'm not trying to shift an object
to a new tablespace and WAL backups are happening (recent files
in the pgbackrest backup dir).

AP


pgsql-bugs by date:

Previous
From: Sergei Kornilov
Date:
Subject: Re: BUG #15582: ALTER TABLE/INDEX ... SET TABLESPACE does not free disk space
Next
From: PG Bug reporting form
Date:
Subject: BUG #15586: Failed to start PostgreSQL Cluster 10-main