| From: | Jeff Eckermann <jeff_eckermann(at)yahoo(dot)com> |
|---|---|
| To: | Andreas Rust <rust(at)webnova(dot)de>, Martijn van Oosterhout <kleptog(at)svana(dot)org>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Postgres Databases growing without much reason |
| Date: | 2003-02-14 15:06:07 |
| Message-ID: | 20030214150607.51422.qmail@web20801.mail.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
--- Andreas Rust <rust(at)webnova(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Egyud Csaba | 2003-02-14 15:06:45 | Re: set returning functions in v7.3 - SORRY |
| Previous Message | Greg Stark | 2003-02-14 15:02:29 | Re: Diff between Primary key and non primary key select |