Re: BUG #5774: VACCUM & REINDEX kills production environement - Mailing list pgsql-bugs

From Heikki Linnakangas
Subject Re: BUG #5774: VACCUM & REINDEX kills production environement
Date
Msg-id 4CF3D57B.8040307@enterprisedb.com
Whole thread Raw
In response to Re: BUG #5774: VACCUM & REINDEX kills production environement  (Balamurugan Mahendran <balamurugan@adaptavant.com>)
Responses Re: BUG #5774: VACCUM & REINDEX kills production environement  (Balamurugan Mahendran <balamurugan@adaptavant.com>)
List pgsql-bugs
On 29.11.2010 17:16, Balamurugan Mahendran wrote:
> This is how I used to do maintenance through cron job. Please advise if i
> need to change my method, Also I used to run re-index all the time while
> doing Vacuum (cron job updated twice a week).

Most likely you can just remove the reindex commands. Routing reindexing
is not normally needed.

--
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com

pgsql-bugs by date:

Previous
From: Balamurugan Mahendran
Date:
Subject: Re: BUG #5774: VACCUM & REINDEX kills production environement
Next
From: Heikki Linnakangas
Date:
Subject: Re: BUG #5774: VACCUM & REINDEX kills production environement