Horton
Menu

Re: Table size does not include toast size

Bernd Helmle <mailings@oopsware.de>

View thread
From: Bernd Helmle <mailings@oopsware.de>
To: Cédric Villemain <cedric.villemain.debian@gmail.com>, Tom Lane <tgl@sss.pgh.pa.us>
Cc: Greg Smith <greg@2ndquadrant.com>, Rafael Martinez <r.m.guerrero@usit.uio.no>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2009-12-22T14:09:42Z
Lists: pgsql-hackers 

--On 22. Dezember 2009 11:46:32 +0100 Cédric Villemain 
<cedric.villemain.debian@gmail.com> wrote:

> Did you mean :
>  pg_table_size() = base table + toast table
>  pg_indexes_size() = base indexes + toast indexes
> ?

Since you always have a toast index automatically it makes sense to include 
them in pg_table_size().

-- 
Thanks

	Bernd