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

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Erki Eessaar <erki(dot)eessaar(at)taltech(dot)ee>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: System administration functions about relation size ignore changes in the table structure
Date: 2023-10-15 14:21:26
Message-ID: CAKFQuwb_a7rjYAxjNay9i7qRKEdL_NyB9G6yhE8WAMTtF5nM8g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Our convention here is to in-line or bottom post.

On Sunday, October 15, 2023, Erki Eessaar <erki(dot)eessaar(at)taltech(dot)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.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2023-10-15 15:14:45 Re: System administration functions about relation size ignore changes in the table structure
Previous Message Erki Eessaar 2023-10-15 08:27:05 Re: System administration functions about relation size ignore changes in the table structure