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

Re: Integrated autovacuum

From: Martín Marqués <martin(at)bugs(dot)unl(dot)edu(dot)ar>
To: pgsql-hackers(at)postgresql(dot)org
Cc: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>,"Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Subject: Re: Integrated autovacuum
Date: 2005-07-27 21:05:26
Message-ID: 200507271805.28034.martin@bugs.unl.edu.ar (view raw or flat)
Thread:
Lists: pgsql-hackers
El Mié 27 Jul 2005 17:24, Alvaro Herrera escribió:
> On Wed, Jul 27, 2005 at 12:53:40PM -0700, Joshua D. Drake wrote:
> 
> > Just for clarification, will the new integrated autovacuum require that 
> > statistics are on?
> 
> Yes.  Row-level stats too.

Will there be a way to ballance the amount of stats the autovacuum gets? 
Something like the analyze parameters that the contrib version has, but 
integrated in postgresql.conf?

I had a select on my development server that took several minutes to complete, 
and after running manually analyze on the tables involved the time reduced 
dramatically.

Running on a 8.0.3 server with autovacuum running every 5 minutes.

-- 
 17:52:04 up 25 days,  2:37,  1 user,  load average: 0.90, 1.00, 0.97
-------------------------------------------------
Lic. Martín Marqués   | SELECT 'mmarques' || 
Centro de Telemática  |     '@' || 'unl.edu.ar';
Universidad Nacional  | DBA, Programador, 
    del Litoral       | Administrador
-------------------------------------------------

In response to

Responses

pgsql-hackers by date

Next:From: Joshua D. DrakeDate: 2005-07-27 21:07:28
Subject: Re: Integrated autovacuum
Previous:From: Dave PageDate: 2005-07-27 20:52:08
Subject: Re: --enable-thread-safety on Win32

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