Re: Reducing memory usage of insert into select operations?

Поиск
Список
Период
Сортировка
От Francisco Reyes
Тема Re: Reducing memory usage of insert into select operations?
Дата
Msg-id ac44dd59c6c8b8eacfe38e074f11af87@stringsutils.com
обсуждение исходный текст
Ответ на Re: Reducing memory usage of insert into select operations?  ("Douglas McNaught" <doug@mcnaught.org>)
Ответы Re: Reducing memory usage of insert into select operations?  (Martijn van Oosterhout <kleptog@svana.org>)
Список pgsql-general
Дерево обсуждения 
On 9:53 am 07/18/08 "Douglas McNaught" <doug@mcnaught.org> wrote:
> dedicated database server you really don't ever want to have the OOM
> killer triggered.

Found that yesterday (vm.overcommit_memory=2).
Agree that this is better than OOM. I still ran out of memory last night
and postgres just failed on the malloc(), which as you mentioned is better.

Reduced work_mem to 8MB and trying again.

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

Предыдущее
От: "Kevin Duffy"
Дата:
Сообщение: Re: query optimization
Следующее
От: "Francisco Reyes"
Дата:
Сообщение: Re: Reducing memory usage of insert into select operations?