Re: automatic REINDEX-ing - Mailing list pgsql-general

From Ow Mun Heng
Subject Re: automatic REINDEX-ing
Date
Msg-id 1218599219.24223.18.camel@neuromancer.home.net
Whole thread Raw
In response to Re: automatic REINDEX-ing  (Lennin Caro <lennin.caro@yahoo.com>)
List 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?

pgsql-general by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Is the primary key constraint also an index?
Next
From: "Sathish Duraiswamy"
Date:
Subject: Re: Need help returning record set from a dynamic sql query