Re: Integrated autovacuum

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
-------------------------------------------------