| From: | "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | "Rafael Domiciano" <rafael(dot)domiciano(at)gmail(dot)com> |
| Cc: | "Rafael Martinez" <r(dot)m(dot)guerrero(at)usit(dot)uio(dot)no>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Vacuum Problems |
| Date: | 2008-11-26 15:40:41 |
| Message-ID: | dcc563d10811260740m69f8969bt36be6ae675620dcb@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
2008/11/26 Rafael Domiciano <rafael(dot)domiciano(at)gmail(dot)com>:
> The database has around 40 Gb.
> If I not use vacuum full everyday the database get very slow.
>
> There is no deadlock on the database.
You didn't mention if you were using autovacuum or not. You also
didn't mention whether or not you'd tried regular vacuums if for some
reason you can't use autovacuum. Vacuum full is very intrusive and
can cause index bloat. It's more of a repair operation than a routine
maintenance one.
What do the last 10 or so lines of vacuum verbose run as a super user say?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rafael Domiciano | 2008-11-26 17:21:39 | Re: Vacuum Problems |
| Previous Message | Rafael Domiciano | 2008-11-26 15:00:54 | Re: Vacuum Problems |