Re: Table size does not include toast size

On Mon, Dec 21, 2009 at 5:02 PM, Greg Smith <greg@2ndquadrant.com> wrote:
> Tom Lane wrote:
>>
>> Perhaps invent  pg_table_size() = base table + toast table + toast index
>> and             pg_indexes_size() = all other indexes for table
>> giving us the property pg_table_size + pg_indexes_size =
>> pg_total_relation_size
>>
>
> Right; that's exactly the way I'm computing things now, I just have to crawl
> way too much catalog data to do it.  I also agree that if we provide
> pg_table_size, the issue of "pg_relation_size doesn't do what I want" goes
> away without needing to even change the existing documentation--people don't
> come to that section looking for "relation", they're looking for "table".
>
> Bernd, there's a basic spec if you have time to work on this.

What about, the visibility maps and free space maps?


--
greg