On Wed, Dec 3, 2008 at 2:00 AM, Tom Lane <[EMAIL PROTECTED]> wrote:
> It seems like mostly a confusion-generator to me.  Is there any actual
> evidence that autovac should use a different maintenance_work_mem than
> other processes?

IMHO, the point is that we were used to consider the
maintenance_work_mem as a "one process at a time" thing. Even if it's
not really true, we usually didn't do maintenance task on a concurrent
basis.
The autovacuum workers change that and make it a default behaviour (as
we can have 3*maintenance_work_mem by default).

>From my point of view, the best solution would be to share the
maintenance_work_mem amongst all the workers but I suppose it's not
technically possible.

-- 
Guillaume

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to