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

From Sergei Kornilov
Subject Re: BUG #15582: ALTER TABLE/INDEX ... SET TABLESPACE does not free disk space
Date
Msg-id 43232061547113498@myt4-929fb874f3f2.qloud-c.yandex.net
Whole thread Raw
In response to Re: BUG #15582: ALTER TABLE/INDEX ... SET TABLESPACE does not freedisk space  (AP <ap@zip.com.au>)
Responses Re: BUG #15582: ALTER TABLE/INDEX ... SET TABLESPACE does not freedisk space
List pgsql-bugs
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.
 

regards, Sergei


pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #15585: infinite DynamicSharedMemoryControlLock waiting inparallel query
Next
From: AP
Date:
Subject: Re: BUG #15582: ALTER TABLE/INDEX ... SET TABLESPACE does not freedisk space