Skip site navigation (1)
Skip section navigation (2)
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
Peripheral Links
Header And Logo
|
Site Navigation
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: Tue, 29 May 2007 11:36:57 -0400
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
- Follow-Ups:
- Fwd: Out of Memory on Reindex
- From: Chris Hoover
- Fwd: Out of Memory on Reindex
- Prev by Date: Re: PostgreSQL Training?
- Next by Date: Grant SELECT on all tables of a database
- Previous by thread: Attempt to re-archive existing WAL logs after restoring from backup
- Next by thread: Fwd: Out of Memory on Reindex
- Indexes: