Re: autovacuum maintenance_work_mem

Поиск
Список
Период
Сортировка
От Itagaki Takahiro
Тема Re: autovacuum maintenance_work_mem
Дата
Msg-id AANLkTimb4HeaYPS2-CO_Rt_btSY6FiDUHDjRHyXkTfuY@mail.gmail.com
обсуждение исходный текст
Ответ на autovacuum maintenance_work_mem  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Ответы Re: autovacuum maintenance_work_mem  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: GCC vs clang
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: GiST insert algorithm rewrite