Postgres Pro
Downloads
Home   >   mailing lists

Re: Vacuuming technique doubt - Mailing list pgsql-performance

From S Arvind
Subject Re: Vacuuming technique doubt
Date
Msg-id abf9211d0906011101h356d0670xfe7c3fdadbf73dc6@mail.gmail.com
Whole thread Raw
In response to Re: Vacuuming technique doubt  (Greg Smith <gsmith@gregsmith.com>)
Responses Re: Vacuuming technique doubt
List pgsql-performance
Tree view
Hi Smith,
The reason why we need it manually is , we don't need any  performance drop in our production hours. So we figured out the most less usage working time, most freq used tables and want to perform that  on daily . so in weekends we can vaccum and reindex entire db.. Is the model is not more efficient Smith?

-Arvind S


"Many of lifes failure are people who did not realize how close they were to success when they gave up."
-Thomas Edison


On Mon, Jun 1, 2009 at 9:04 PM, Greg Smith <gsmith@gregsmith.com> wrote:
On Mon, 1 Jun 2009, S Arvind wrote:

Having a doubt, we want to vacuum and reindex some 50 most used tables daily on specific time. Is it best to have a function in
postgres and call it in cron or is there any other good way to do the two process for specified tables at specified time?

If you haven't been using VACUUM properly, it's possible to get into a position where you need to REINDEX your tables and go through the sort of giant cleanup step you describe.  If you think you need to do that daily, though, you probably should take a look at tuning autovacuum rather than trying to fix the problem manually all the time.

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD

pgsql-performance by date:

Previous
From: Alan McKay
Date:
Subject: Re: Best way to load test a postgresql server
Next
From: Anne Rosset
Date:
Subject: Re: Unexpected query plan results