| From: | Jan Otto <asche(at)me(dot)com> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Rainer Bauer <usenet(at)munnin(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Space for pg_dump |
| Date: | 2009-04-20 17:39:34 |
| Message-ID: | 90410B09-E1CB-45E1-BC5D-10D4FE86F6AF@me.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Apr 20, 2009, at 7:35 PM, Alvaro Herrera wrote:
> Jan Otto wrote:
>
>> If you have big toast tables you get wrong results with the query
>> suggested
>> at http://wiki.postgresql.org/wiki/Disk_Usage because it takes the
>> toasted
>> values not into account.
>
>
>> Now a fixed query which gets the sizes of the related pg_toast_oid
>> and
>> pg_toast_oid_index too:
>
> Note that there is also the pg_total_relation_size function which will
> report the total table size, including toast table and indexes.
Ahhh, it was a long day... sometimes i think too complicated ;-)
regards, jan
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bob Pawley | 2009-04-20 17:42:55 | Re: postgreSQL & amazon ec2 cloud |
| Previous Message | Alvaro Herrera | 2009-04-20 17:35:37 | Re: Space for pg_dump |