Postgres Pro
Downloads
Home   >   mailing lists

Re: System administration functions about relation size ignore changes in the table structure - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: System administration functions about relation size ignore changes in the table structure
Date
Msg-id CAKFQuwb_a7rjYAxjNay9i7qRKEdL_NyB9G6yhE8WAMTtF5nM8g@mail.gmail.com
Whole thread Raw
In response to Re: System administration functions about relation size ignore changes in the table structure  (Erki Eessaar <erki.eessaar@taltech.ee>)
List pgsql-bugs
Tree view
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 by date:

Previous
From: Erki Eessaar
Date:
Subject: Re: System administration functions about relation size ignore changes in the table structure
Next
From: Tom Lane
Date:
Subject: Re: System administration functions about relation size ignore changes in the table structure