| From: | Neil Conway <neilc(at)samurai(dot)com> |
|---|---|
| To: | "Ed L(dot)" <pgsql(at)bluepolka(dot)net> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: 8.0.0beta3 vacuum analyze |
| Date: | 2004-10-18 06:43:26 |
| Message-ID: | 1098081806.22986.309.camel@localhost.localdomain |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, 2004-10-18 at 14:49, Ed L. wrote:
> I *think* I'm seeing "vacuum analyze" queries launched automatically on an
> 8.0.0beta3 (unless I have a rogue autovac running that I haven't spotted).
> Is this something new in 8.0 and to be expected?
No.
> #vacuum_cost_delay = 0 # 0-1000 milliseconds
> #vacuum_cost_page_hit = 1 # 0-10000 credits
> #vacuum_cost_page_miss = 10 # 0-10000 credits
> #vacuum_cost_page_dirty = 20 # 0-10000 credits
> #vacuum_cost_limit = 200 # 0-10000 credits
Vacuum cost delay affects the way that VACUUM behaves, not the frequency
with which it is executed.
-Neil
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tham Paudel | 2004-10-18 11:25:42 | Problem |
| Previous Message | Kris Jurka | 2004-10-18 05:42:01 | Re: [JDBC] create view problem |