Re: Out of Memory - 8.2.4 - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Out of Memory - 8.2.4
Date
Msg-id 20070830132629.GE5872@alvh.no-ip.org
Whole thread Raw
In response to Re: Out of Memory - 8.2.4  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tom Lane escribió:
> "Marko Kreen" <markokr@gmail.com> writes:
> > Note that it's much better to err on the smaller values.
>
> > Extra index pass is really no problem.
>
> I beg to differ ...
>
> What this may actually suggest is that autovacuum needs its own value of
> "maintenance_work_mem", or that it should automatically divide the value
> by the authorized number of workers.

Hmm, this makes sense.

--
Alvaro Herrera       Valdivia, Chile   ICBM: S 39º 49' 18.1", W 73º 13' 56.4"
"Cómo ponemos nuestros dedos en la arcilla del otro. Eso es la amistad; jugar
al alfarero y ver qué formas se pueden sacar del otro" (C. Halloway en
La Feria de las Tinieblas, R. Bradbury)

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Out of Memory - 8.2.4
Next
From: Alvaro Herrera
Date:
Subject: Re: Out of Memory - 8.2.4