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

From: Sergei Kornilov <sk(at)zsrv(dot)org>
To: AP <ap(at)zip(dot)com(dot)au>, Andres Freund <andres(at)anarazel(dot)de>
Cc: "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: BUG #15582: ALTER TABLE/INDEX ... SET TABLESPACE does not free disk space
Date: 2019-01-10 09:44:58
Message-ID: 43232061547113498@myt4-929fb874f3f2.qloud-c.yandex.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi
If archiver can not save WAL - postgresql will not remove these WAL and pg_wal directory will grow unlimited. And i think your alter table set tablespace works ok and table was removed from original disk. But was fully copied to WAL and such WAL can not be deleted, therefore overall disk space usage is same. So you need repair you archive_command first.

regards, Sergei

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message AP 2019-01-10 10:40:54 Re: BUG #15582: ALTER TABLE/INDEX ... SET TABLESPACE does not free disk space
Previous Message PG Bug reporting form 2019-01-10 09:21:24 BUG #15585: infinite DynamicSharedMemoryControlLock waiting in parallel query