Re: Fwd: Out of Memory on Reindex - Mailing list pgsql-admin

From Tom Lane
Subject Re: Fwd: Out of Memory on Reindex
Date
Msg-id 21900.1180562115@sss.pgh.pa.us
Whole thread Raw
In response to Fwd: Out of Memory on Reindex  ("Chris Hoover" <revoohc@gmail.com>)
Responses Re: Fwd: Out of Memory on Reindex  ("Chris Hoover" <revoohc@gmail.com>)
List 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 by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: pg_dump: Error message from server: ERROR: compressed data is corrupt
Next
From: Adam Tauno Williams
Date:
Subject: Re: High Avaliable in the PostgreSQL.