| From: | Ow Mun Heng <Ow(dot)Mun(dot)Heng(at)wdc(dot)com> |
|---|---|
| To: | lennin(dot)caro(at)yahoo(dot)com |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org>, Joao Ferreira gmail <joao(dot)miguel(dot)c(dot)ferreira(at)gmail(dot)com> |
| Subject: | Re: automatic REINDEX-ing |
| Date: | 2008-08-13 03:46:59 |
| Message-ID: | 1218599219.24223.18.camel@neuromancer.home.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, 2008-08-12 at 08:38 -0700, Lennin Caro wrote:
> you can use a cron job
>
I have my cron setup to do database wide vacuums each night and it
usually takes ~between 4-6 hours on ~200G DB size.
On days where there is huge activity, it can drag on for like 15+ hours.
I've recently dropped all my indexes and started to only rebuild _some_
needed ones.
What's the method for looking at index bloats anyway?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sathish Duraiswamy | 2008-08-13 04:10:51 | Re: Need help returning record set from a dynamic sql query |
| Previous Message | Craig Ringer | 2008-08-13 02:41:50 | Re: Is the primary key constraint also an index? |