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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
-------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2005-07-27 21:07:28 | Re: Integrated autovacuum |
Previous Message | Dave Page | 2005-07-27 20:52:08 | Re: --enable-thread-safety on Win32 |