Re: Space for pg_dump - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Space for pg_dump
Date
Msg-id 20090420173537.GD10358@alvh.no-ip.org
Whole thread Raw
In response to Re: Space for pg_dump  (Jan Otto <asche@me.com>)
Responses Re: Space for pg_dump
List pgsql-general
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.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

pgsql-general by date:

Previous
From: Jan Otto
Date:
Subject: Re: Space for pg_dump
Next
From: Jan Otto
Date:
Subject: Re: Space for pg_dump