Re: Integrated autovacuum

On Wed, Jul 27, 2005 at 06:05:26PM -0300, Martín Marqués wrote:
> 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'm not sure I understand your question. If it means what I think, then
yes, you can set the threshold and scale values per table.

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

I think everybody mostly agreed that contrib's pg_autovacuum default
values were too conservative.

--
Alvaro Herrera (<alvherre[a]alvh.no-ip.org>)
"Las cosas son buenas o malas segun las hace nuestra opinión" (Lisias)