Horton

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

David G. Johnston <david.g.johnston@gmail.com>

View thread
From: "David G. Johnston" <david.g.johnston@gmail.com>
To: Erki Eessaar <erki.eessaar@taltech.ee>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, "pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>
Date: 2023-10-15T14:21:26Z
Lists: 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.