Re: frustration with database size - Mailing list pgsql-general

From Tom Lane
Subject Re: frustration with database size
Date
Msg-id 4923.1011555451@sss.pgh.pa.us
Whole thread Raw
In response to frustration with database size  (Andrew Gould <andrewgould@yahoo.com>)
Responses Re: frustration with database size  (Andrew Gould <andrewgould@yahoo.com>)
List pgsql-general
Andrew Gould <andrewgould@yahoo.com> writes:
> The process above resulted in an **increase** in
> database size from 12GB to 14GB.
> I'm both surprised and stumped.

Seems odd to me too.  Like Einar, I am wondering about index sizes.

An easy way to get some data is to do a VACUUM so that the relpages
statistics are up to date, and then do

select relname,relkind,relpages from pg_class order by relpages desc;

            regards, tom lane

pgsql-general by date:

Previous
From: "Tim Barnard"
Date:
Subject: Re: Clarification question
Next
From: Jochem van Dieten
Date:
Subject: PL/pgSQL: dynamic tablename