Re: Space for pg_dump

On Mon, 20 Apr 2009, 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.

I can't recall why I wrote that to filter out things in the pg_toast
namespace in the first place. I just took the easy way out here--the
query has been updated to not exclude relations in that namespace anymore
and I link to the TOAST docs for more details.

I consider combining all the values together, as you did in your example
code and as pg_total_relation_size does, as a different type of report.
Accordingly, I just updated with examples of both types, as well as
something to work against pre-8.1 databases.

--
* Greg Smith gsmith(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD