Re: autovacuum maintenance_work_mem - Mailing list pgsql-hackers

From Itagaki Takahiro
Subject Re: autovacuum maintenance_work_mem
Date
Msg-id AANLkTimb4HeaYPS2-CO_Rt_btSY6FiDUHDjRHyXkTfuY@mail.gmail.com
Whole thread Raw
In response to autovacuum maintenance_work_mem  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Responses Re: autovacuum maintenance_work_mem
List pgsql-hackers
On Wed, Nov 17, 2010 at 01:12, Alvaro Herrera <alvherre@alvh.no-ip.org> wrote:
> So for the initial implementation, we could just have each worker set
> its local maintenance_work_mem to autovacuum_maintenance_memory / max_workers.
> That way there's never excessive memory usage.

It sounds reasonable, but is there the same issue for normal connections?
We can limit max connections per user, but there are no quota for total
memory consumed by the user. It might not be an autovacuum-specifix issue.

-- 
Itagaki Takahiro


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: GCC vs clang
Next
From: Heikki Linnakangas
Date:
Subject: GiST insert algorithm rewrite