Re: pg_dump error - out of memory, Failed on request of size 536870912

Поиск
Список
Период
Сортировка
От Stefan Kaltenbrunner
Тема Re: pg_dump error - out of memory, Failed on request of size 536870912
Дата
Msg-id 48999A0E.7040007@kaltenbrunner.cc
обсуждение исходный текст
Ответ на Re: pg_dump error - out of memory, Failed on request of size 536870912  (Marcin Citowicki <marcin.citowicki@m4n.nl>)
Список pgsql-performance
Дерево обсуждения 
Marcin Citowicki wrote:
> Hello,
>
> I forgot to add - all those 'out of memory' errors happen when backup db
> is trying to create index. Every 'CREATE INDEX' operation is followed by
> 'out of memory' error.

are you sure that your OS (or ulimit) is able to support a
maintenance_work_setting that large ? - try reducing to a say 128MB for
a start and try again.


Stefan

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

Предыдущее
От: "Pavel Stehule"
Дата:
Сообщение: Re: pg_dump error - out of memory, Failed on request of size 536870912
Следующее
От: "Joshua Shanks"
Дата:
Сообщение: query planner not using the correct index