| From: | Greg Smith <gsmith(at)gregsmith(dot)com> |
|---|---|
| To: | S Arvind <arvindwill(at)gmail(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Vacuuming technique doubt |
| Date: | 2009-06-01 15:34:53 |
| Message-ID: | alpine.GSO.2.01.0906011132030.4192@westnet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shaul Dar | 2009-06-01 15:46:22 | Using index for bitwise operations? |
| Previous Message | Tom Lane | 2009-06-01 14:06:12 | Re: degenerate performance on one server of 3 |