| From: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> |
|---|---|
| To: | "A(dot)Bhuvaneswaran" <bhuvansql(at)myrealbox(dot)com> |
| Cc: | Raquel Vieira <raquel(dot)vieira(at)ent(dot)efacec(dot)pt>, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Vacuumdb |
| Date: | 2003-04-03 19:22:40 |
| Message-ID: | 1049397760.13799.5274.camel@camel |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Thu, 2003-04-03 at 00:13, A.Bhuvaneswaran wrote:
> > I'm using PostgreSQL 7.0.3.
> > I'm doing vacuumdb in my database every night to repair it. But now I have a
> > problem. I'm looking in /var/lib/pgsql/data/base/ for the tables length and
> > the primary keys of the tables are not cleaned and is increasing evey day.
> > What can I do to clean it?
> > Thank you for the help.
>
> If you mean hard disk space consumption, you might have to run vacuum
> full.
>
Actually the vacuum in 7.0.3 is a vacuum full. I'm guessing the problem
is really index bloat, try dropping and recreating some of your indexes.
After that you need to seriously look at upgrading.
Robert Treat
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kris Kiger | 2003-04-03 19:26:36 | Re: Speed & Memory Management |
| Previous Message | Jodi Kanter | 2003-04-03 18:22:08 | Re: Speed & Memory Management |