Re: System administration functions about relation size ignore changes in the table structure

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: System administration functions about relation size ignore changes in the table structure
Дата
Msg-id CAKFQuwb_a7rjYAxjNay9i7qRKEdL_NyB9G6yhE8WAMTtF5nM8g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: System administration functions about relation size ignore changes in the table structure  (Erki Eessaar <erki.eessaar@taltech.ee>)
Список pgsql-bugs
Дерево обсуждения
Our convention here is to in-line or bottom post.

On Sunday, October 15, 2023, Erki Eessaar <erki.eessaar@taltech.ee> wrote:
After that I dropped ALL the columns of the table (by the way it is a nice feature that PostgreSQL allows tables without columns). VACUUM ANALYZE did not change the relation size. VACUUM FULL reduced the size, but it was still pretty large. 

Rows have overhead so even a zero column row is going to take up space.

David J. 

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

Предыдущее
От: Erki Eessaar
Дата:
Сообщение: Re: System administration functions about relation size ignore changes in the table structure
Следующее
От: Tom Lane
Дата:
Сообщение: Re: System administration functions about relation size ignore changes in the table structure