Re: frustration with database size

Thanks!  I must have missed dropping/recreating one of
the primary key indexes.  The relpages for the index
exceeded the relpages for the table.

I dropped and recreated the index, and vacuumed the
database.  The overall database size is down to 11GB.
It's still large; but at least the numbers make more
sense.

Thanks again,

Andrew Gould

--- Tom Lane <tgl@sss.pgh.pa.us> wrote:
> 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
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html


__________________________________________________
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/