Re: Postgres Databases growing without much reason - Mailing list pgsql-general

From Jeff Eckermann
Subject Re: Postgres Databases growing without much reason
Date
Msg-id 20030214150607.51422.qmail@web20801.mail.yahoo.com
Whole thread Raw
In response to Re: Postgres Databases growing without much reason  (Andreas Rust <rust@webnova.de>)
List pgsql-general
--- Andreas Rust <rust@webnova.de> wrote:

> After an advice, I just did "vacuum full" instead of
> analyze and that
> brought the DB
> down to some 350 MB again ...

That will shrink the on-disk size of the tables, but
not the indexes.  There is work going on to fix this
for the next version of PostgreSQL, but in the
meantime you will need to look at a workaround if
index growth becomes a problem for you.  Search the
archives for references to "index bloat" and "reindex"
and you should find plenty of stuff.

__________________________________________________
Do you Yahoo!?
Yahoo! Shopping - Send Flowers for Valentine's Day
http://shopping.yahoo.com

pgsql-general by date:

Previous
From: Greg Stark
Date:
Subject: Re: Diff between Primary key and non primary key select
Next
From: Jeff Eckermann
Date:
Subject: Re: uppercase = lowercase