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
-------------------------------------------------
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
