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

From Tom Lane
Subject Re: Out of Memory - 8.2.4
Date
Msg-id 26186.1188480237@sss.pgh.pa.us
Whole thread Raw
In response to Re: Out of Memory - 8.2.4  ("Marko Kreen" <markokr@gmail.com>)
Responses Re: Out of Memory - 8.2.4
Re: Out of Memory - 8.2.4
List pgsql-general
"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.

            regards, tom lane

pgsql-general by date:

Previous
From: "Roberto Icardi"
Date:
Subject: rules and rows affected
Next
From: Alvaro Herrera
Date:
Subject: Re: Out of Memory - 8.2.4