Skip site navigation (1)
Skip section navigation (2)
maintenance_work_mem = 1048576 (I have 9GB ram on this server).
Chris
Peripheral Links
Header And Logo
|
Site Navigation
Re: Fwd: Out of Memory on Reindex
- From: "Chris Hoover" <revoohc(at)gmail(dot)com>
- To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
- Subject: Re: Fwd: Out of Memory on Reindex
- Date: Thu, 31 May 2007 10:07:14 -0400
maintenance_work_mem = 1048576 (I have 9GB ram on this server).
Chris
On 5/30/07, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us
> wrote:
"Chris Hoover" <revoohc(at)gmail(dot)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
- Follow-Ups:
- Re: Fwd: Out of Memory on Reindex
- From: Tom Lane
- Re: Fwd: Out of Memory on Reindex
- References:
- Out of Memory on Reindex
- From: Chris Hoover
- Fwd: Out of Memory on Reindex
- From: Chris Hoover
- Re: Fwd: Out of Memory on Reindex
- From: Tom Lane
- Out of Memory on Reindex
- Prev by Date: Re: Attempt to re-archive existing WAL logs after restoring from backup
- Next by Date: Re: Fwd: Out of Memory on Reindex
- Previous by thread: Re: Fwd: Out of Memory on Reindex
- Next by thread: Re: Fwd: Out of Memory on Reindex
- Indexes: