| From: | "Simon Riggs" <simon(at)2ndquadrant(dot)com> |
|---|---|
| To: | "Alvaro Herrera" <alvherre(at)commandprompt(dot)com> |
| Cc: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, <pgsql-patches(at)postgresql(dot)org> |
| Subject: | Re: log_autovacuum |
| Date: | 2007-04-18 07:14:42 |
| Message-ID: | 1176880483.3635.561.camel@silverbirch.site |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-patches pgsql-www |
On Tue, 2007-04-17 at 21:45 -0400, Alvaro Herrera wrote:
> Alvaro Herrera wrote:
>
> > Seems fair. Updated patch attached.
> >
> > If there are no further comments, I'll add some docs and apply it later.
>
> If autovacuum_vacuum_cost_delay is set to 20, my pitiful desktop system
> takes 8.4 seconds to analyze a 8000 page table:
>
> DEBUG: "bar": scanned 3000 of 8811 pages, containing 681000 live rows and 0 dead rows; 3000 rows in sample, 2000097 estimated total rows
> LOG: automatic analyze of table "alvherre.public.bar" system usage: CPU 0.00s/0.01u sec elapsed 8.39 sec
>
> So I guess logging on ANALYZE is not that removed from reality.
>
> I also think we should remove these DEBUG messages, that are now
> useless:
>
> DEBUG: autovac: will ANALYZE bar
Looks good.
--
Simon Riggs
EnterpriseDB http://www.enterprisedb.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Magnus Hagander | 2007-04-18 08:32:51 | Re: Suppress warnings on mingw |
| Previous Message | Tom Lane | 2007-04-18 04:59:55 | Re: log_autovacuum |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Selena Deckelmann | 2007-04-18 15:34:35 | access to PDXPUG page for Gabrielle |
| Previous Message | Tom Lane | 2007-04-18 04:59:55 | Re: log_autovacuum |