Re: 7.1 Beta 1 & table size calculation

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Dale Anderson" <danderso(at)crystalsugar(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: 7.1 Beta 1 & table size calculation
Date: 2000-12-21 16:03:12
Message-ID: 16576.977414592@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Dale Anderson" <danderso(at)crystalsugar(dot)com> writes:
> Is the relpages counts under 7.1 no longer valid of the physical page
> storage?

It's still valid, but you need to include the associated TOAST table
as well as the primary relation.

Keep in mind also that TOAST can do inline compression. If you made
your test record with something like repeat('x',29000), it probably
got compressed to not very many bytes ...

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2000-12-21 16:12:48 Re: Very slow select
Previous Message Mike Castle 2000-12-21 15:50:27 Re: red hat/mysql fiasco