Skip site navigation (1) Skip section navigation (2)

Re: log_autovacuum

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 (view raw or flat)
Thread:
Lists: pgsql-patchespgsql-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



In response to

Responses

pgsql-www by date

Next:From: Selena DeckelmannDate: 2007-04-18 15:34:35
Subject: access to PDXPUG page for Gabrielle
Previous:From: Tom LaneDate: 2007-04-18 04:59:55
Subject: Re: log_autovacuum

pgsql-patches by date

Next:From: Magnus HaganderDate: 2007-04-18 08:32:51
Subject: Re: Suppress warnings on mingw
Previous:From: Tom LaneDate: 2007-04-18 04:59:55
Subject: Re: log_autovacuum

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group