"Chris Hoover" <revoohc(at)gmail(dot)com> writes:
> I am getting the following error when trying to run a reindex on one of my
> 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
In response to
pgsql-admin by date
|Next:||From: Adam Tauno Williams||Date: 2007-05-30 22:12:02|
|Subject: Re: High Avaliable in the PostgreSQL.|
|Previous:||From: Alvaro Herrera||Date: 2007-05-30 21:23:27|
|Subject: Re: pg_dump: Error message from server: ERROR: compressed data is corrupt|