Re: 7.1 Beta 1 & table size calculation - Mailing list pgsql-general

From Tom Lane
Subject Re: 7.1 Beta 1 & table size calculation
Date
Msg-id 16576.977414592@sss.pgh.pa.us
Whole thread Raw
In response to 7.1 Beta 1 & table size calculation  ("Dale Anderson" <danderso@crystalsugar.com>)
List pgsql-general
"Dale Anderson" <danderso@crystalsugar.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

pgsql-general by date:

Previous
From: Mike Castle
Date:
Subject: Re: red hat/mysql fiasco
Next
From: "Mike Sears"
Date:
Subject: Re: red hat/mysql fiasco