Re: Fwd: Out of Memory on Reindex

"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