Re: VACUUM FULL doesn't reduce table size

Поиск
Список
Период
Сортировка
От Vick Khera
Тема Re: VACUUM FULL doesn't reduce table size
Дата
Msg-id CALd+dcfDtydsO7fdR_so0ZhRFhSeQ0vg3NCkp+CUpYemhfWyAQ@mail.gmail.com
обсуждение исходный текст
Ответ на VACUUM FULL doesn't reduce table size  (pinker <pinker@onet.eu>)
Ответы Re: VACUUM FULL doesn't reduce table size
Re: VACUUM FULL doesn't reduce table size
Список pgsql-general
Дерево обсуждения

On Fri, Mar 6, 2015 at 5:59 AM, pinker <pinker@onet.eu> wrote:
I have deleted a large number of records from my_table, which originally had
288 MB. Then I ran vacuum full to make the table size smaller. After this
operation size of the table remains the same, despite of the fact that table

If your remaining records were in say, block 2 and block 10000, then the blocks in between won't be returned to the system.

You could achieve your "fix" by running cluster on the table, which will rewrite the table in-place.  There are also scripts out there that do in-place compaction by running targeted updates and vacuum commands to get the empty pages at the end of the files truncated off the file.

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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: pg_upgrade failing from 9.3 to 9.4 because "template0" already exists
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: pg_upgrade failing from 9.3 to 9.4 because "template0" already exists