Re: Table size does not include toast size

From: Bernd Helmle <mailings(at)oopsware(dot)de>
To: Cédric Villemain <cedric(dot)villemain(dot)debian(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Greg Smith <greg(at)2ndquadrant(dot)com>, Rafael Martinez <r(dot)m(dot)guerrero(at)usit(dot)uio(dot)no>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Table size does not include toast size
Date: 2009-12-22 14:09:42
Message-ID: 30E6478652370597ACE6BC32@[172.26.14.62]
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

--On 22. Dezember 2009 11:46:32 +0100 Cédric Villemain
<cedric(dot)villemain(dot)debian(at)gmail(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bernd Helmle 2009-12-22 14:11:40 Re: Table size does not include toast size
Previous Message Heikki Linnakangas 2009-12-22 14:09:26 Re: alpha3 release schedule?