Re: Fwd: Out of Memory on Reindex

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Fwd: Out of Memory on Reindex
Дата
Msg-id 21900.1180562115@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Fwd: Out of Memory on Reindex  ("Chris Hoover" <revoohc@gmail.com>)
Ответы Re: Fwd: Out of Memory on Reindex  ("Chris Hoover" <revoohc@gmail.com>)
Список pgsql-admin
"Chris Hoover" <revoohc@gmail.com> writes:
> I am getting the following error when trying to run a reindex on one of my
> databases.

> reindexdb: reindexing of database "xxx" failed: ERROR:  out of memory
> DETAIL:  Failed on request of size 268435456.

> Can someone advise on what memory parameter was violated?

Kernel's process size limit (ulimit -m or something like that).

What have you got maintenance_work_mem set to ... 256MB by any chance?
If so make it less.

            regards, tom lane

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: pg_dump: Error message from server: ERROR: compressed data is corrupt
Следующее
От: Adam Tauno Williams
Дата:
Сообщение: Re: High Avaliable in the PostgreSQL.