Home > mailing lists

Out of Memory on Reindex - Mailing list pgsql-admin

From	Chris Hoover
Subject	Out of Memory on Reindex
Date	May 29, 2007 15:38:17
Msg-id	1d219a6f0705290836h67b9509egc62498c78cf39829@mail.gmail.com Whole thread Raw
Responses	Fwd: Out of Memory on Reindex
List	pgsql-admin

Tree view

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

pgsql-admin by date:

From: Joshua Kramer
Date: 29 May 2007, 14:05:46
Subject: Re: PostgreSQL Training?

From: Marsha Ramsey
Date: 29 May 2007, 17:21:12
Subject: Grant SELECT on all tables of a database

Out of Memory on Reindex - Mailing list pgsql-admin

Previous

Next