VACUUM FULL doesn't reduce table size

Поиск
Список
Период
Сортировка
От pinker
Тема VACUUM FULL doesn't reduce table size
Дата
Msg-id 1425639585904-5840782.post@n5.nabble.com
обсуждение исходный текст
Ответы Re: VACUUM FULL doesn't reduce table size
Re: VACUUM FULL doesn't reduce table size
Список pgsql-general
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
contains now only 241 rows and after rewriting it in classic way: CREATE
TABLE new_table AS SELECT * FROM old_table - new_table size is 24kB.
What went wrong? And how can I remove those blocks?



--
View this message in context: http://postgresql.nabble.com/VACUUM-FULL-doesn-t-reduce-table-size-tp5840782.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


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

Предыдущее
От: wambacher
Дата:
Сообщение: Re: autovacuum worker running amok - and me too ;)
Следующее
От: wambacher
Дата:
Сообщение: Re: autovacuum worker running amok - and me too ;)