Re: Postgres Databases growing without much reason

--- Andreas Rust  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