Re: BUG #15582: ALTER TABLE/INDEX ... SET TABLESPACE does not freedisk space

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