Re: frustration with database size <long>

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Andrew Gould <andrewgould@yahoo.com>
Cc: Postgres Mailing List <pgsql-general@postgresql.org>
Date: 2002-01-20T19:37:31Z
Lists: 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