Out of Memory on Reindex

From: "Chris Hoover" <revoohc(at)gmail(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Out of Memory on Reindex
Date: 2007-05-29 15:36:57
Message-ID: 1d219a6f0705290836h67b9509egc62498c78cf39829@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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? Are we looking at
work_mem, shmmax, or something else?

Thanks,

Chris

PG 8.1.3

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Marsha Ramsey 2007-05-29 17:21:02 Grant SELECT on all tables of a database
Previous Message Joshua Kramer 2007-05-29 13:58:16 Re: PostgreSQL Training?