Postgres Pro
Downloads
Home   >   mailing lists

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

From Chris Hoover
Subject Re: Fwd: Out of Memory on Reindex
Date
Msg-id 1d219a6f0705310707i73292913rdccd98f591529776@mail.gmail.com
Whole thread Raw
In response to Re: Fwd: Out of Memory on Reindex  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Fwd: Out of Memory on Reindex  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tree view
maintenance_work_mem = 1048576 (I have 9GB ram on this server).

Chris

On 5/30/07, Tom Lane <tgl@sss.pgh.pa.us > wrote:
"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: Tom Lane
Date:
Subject: Re: Attempt to re-archive existing WAL logs after restoring from backup
Next
From: Tom Lane
Date:
Subject: Re: Fwd: Out of Memory on Reindex