| From: | Markus Schaber <schabi(at)logix-tt(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Cc: | Carlo Stonebanks <stonec(dot)register(at)sympatico(dot)ca> |
| Subject: | Re: Performace Optimization for Dummies |
| Date: | 2006-09-29 12:25:33 |
| Message-ID: | 451D10BD.6060206@logix-tt.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Hi, Carlo,
Carlo Stonebanks wrote:
> From what I can see, autovacuum is hitting the db's in question about once
> every five minutes. Does this imply an ANALYZE is being done automatically
> that would meet the requirements we are talking about here? Is there any
> benefit ot explicitly performing an ANALYZE?
Autovacuum looks at the modification statistics (they count how much
modifications happened on the table), and decides whether it's time to
VACUUM (reclaim empty space) and ANALYZE (update column value
distributions) the table.
The exact thresholds for Autovacuum to kick in are configurable, see the
docs.
HTH,
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS
Fight against software patents in Europe! www.ffii.org
www.nosoftwarepatents.org
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bill Moran | 2006-09-29 12:58:02 | Re: Performace Optimization for Dummies |
| Previous Message | Markus Schaber | 2006-09-29 12:19:51 | Re: Performace Optimization for Dummies |