Re: autovacuum maintenance_work_mem

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: autovacuum maintenance_work_mem
Дата
Msg-id 201011271904.oARJ4hG17626@momjian.us
обсуждение исходный текст
Ответ на Re: autovacuum maintenance_work_mem  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-hackers
Josh Berkus wrote:
> 
> > I think the difficulty is figuring out what to get the existing
> > workers to give us some memory when a new one comes along.  You want
> > the first worker to potentially use ALL the memory... until worker #2
> > arrives.
> 
> Yeah, doing this would mean that you couldn't give worker #1 all the
> memory, because on most OSes it can't release the memory even if it
> wants to.

FYI, what normally happens in this case is that the memory is pushed to
swap by the kernel and never paged in from swap.

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + It's impossible for everything to be true. +


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Amazon now supporting GPU focused EC2 instances
Следующее
От: Dimitri Fontaine
Дата:
Сообщение: Re: ALTER OBJECT any_name SET SCHEMA name