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: 1d219a6f0705310707i73292913rdccd98f591529776@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
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
>

In response to

Responses

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-2014 The PostgreSQL Global Development Group