On 8/30/07, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> "Marko Kreen" <markokr(at)gmail(dot)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 ...
Well, if Postgres tries to cut down passes by using max memory
then admin is forced to cut down maint_mem for safety reasons...
> 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.
Autovacuum having it's own value and cutting pieces from there
and giving to vacuums is probably the easiest path.
Then the per-backend maint_mem does not need to be large.
In response to
pgsql-general by date
|Next:||From: Alvaro Herrera||Date: 2007-08-30 13:58:20|
|Subject: Re: Out of Memory - 8.2.4|
|Previous:||From: Tom Lane||Date: 2007-08-30 13:39:52|
|Subject: Re: Out of Memory - 8.2.4 |