Skip site navigation (1) Skip section navigation (2)

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: 2007-05-31 14:07:14
Message-ID: (view raw or whole thread)
Lists: pgsql-admin
maintenance_work_mem = 1048576 (I have 9GB ram on this server).


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

In response to


pgsql-admin by date

Next:From: Tom LaneDate: 2007-05-31 14:42:55
Subject: Re: Fwd: Out of Memory on Reindex
Previous:From: Tom LaneDate: 2007-05-31 14:01:53
Subject: Re: Attempt to re-archive existing WAL logs after restoring from backup

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group