| 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 17:33:16 |
| Message-ID: | dcc563d10811260933i398d8573jcde3f293015f709a@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Wed, Nov 26, 2008 at 10:21 AM, Rafael Domiciano
<rafael(dot)domiciano(at)gmail(dot)com> wrote:
> I'm not using autovacuum. Regular vacuum goes ok.
> To see the last 10 lines of verbose i will need to run vacuum tonight
> If a run a reindex before the vacuum full, increase the "speed" of doing
> vacuum? I found something about it googling.
You should look into enabling autovac. You can set the sleep
parameter to 10 or 20 to keep it from hogging your I/O bandwidth.
Also, reindex AFTER the vacuum full, not before.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jan-Peter Seifert | 2008-11-26 18:39:18 | Re: Vacuum Problems |
| Previous Message | Vishal Arora | 2008-11-26 17:25:11 | Re: PgAgent Job Scehduler is NOT running |