Re: frustration with database size <long>

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andrew Gould <andrewgould(at)yahoo(dot)com>
Cc: Postgres Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Re: frustration with database size <long>
Date: 2002-01-20 19:37:31
Message-ID: 4923.1011555451@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Andrew Gould <andrewgould(at)yahoo(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message alavoor 2002-01-20 21:03:41 PostgreSQL Licence: GNU/GPL
Previous Message Tim Barnard 2002-01-20 19:07:58 Re: Clarification question