Vacuum full of parent without partitions possible?

Поиск
Список
Период
Сортировка
От Jan Keirse
Тема Vacuum full of parent without partitions possible?
Дата
Msg-id CAH=XL3dxamUiD0Bt80H=L4fcbokacMHQ4Yt-v9S2waut8PtqFA@mail.gmail.com
обсуждение исходный текст
Ответы Re: Vacuum full of parent without partitions possible?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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."

В списке pgsql-general по дате отправления:

Предыдущее
От: Alban Hertroys
Дата:
Сообщение: Re: (VERY) Slow Query - PostgreSQL 9.2
Следующее
От: "Mike Sofen"
Дата:
Сообщение: Re: (VERY) Slow Query - PostgreSQL 9.2