Vacuum full of parent without partitions possible?

From: Jan Keirse <jan(dot)keirse(at)tvh(dot)com>
To: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Vacuum full of parent without partitions possible?
Date: 2016-05-03 11:43:44
Message-ID: CAH=XL3dxamUiD0Bt80H=L4fcbokacMHQ4Yt-v9S2waut8PtqFA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I have a table that used to contain all data.
because it grew too big I added a partition trigger a long time ago and
since than all new data was added to small partitions. By now all data in
the original parent table has become obsolete and was deleted, however the
disk space cannot be reclaimed without a vacuum full. The problem is, a
vacuum full of only the parent table should be instantaneous since it
contains no rows, but because the vacuum full triggers a vacuum of all
partitions too, it's not possible to do this while the application is
running (a vacuum full of all partitions easily takes over an hour during
which the table is locked.)
Is there some workaround for this?

Thanks,

Jan

--

**** DISCLAIMER ****

http://www.tvh.com/glob/en/email-disclaimer

"This message is delivered to all addressees subject to the conditions
set forth in the attached disclaimer, which is an integral part of this
message."

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mike Sofen 2016-05-03 11:53:45 Re: (VERY) Slow Query - PostgreSQL 9.2
Previous Message Alban Hertroys 2016-05-03 11:32:32 Re: (VERY) Slow Query - PostgreSQL 9.2