Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Fwd: Out of Memory on Reindex
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: "Chris Hoover" <revoohc(at)gmail(dot)com>
- Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
- Subject: Re: Fwd: Out of Memory on Reindex
- Date: Wed, 30 May 2007 17:55:15 -0400
"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
- Follow-Ups:
- Re: Fwd: Out of Memory on Reindex
- From: Chris Hoover
- Re: Fwd: Out of Memory on Reindex
- References:
- Out of Memory on Reindex
- From: Chris Hoover
- Fwd: Out of Memory on Reindex
- From: Chris Hoover
- Out of Memory on Reindex
- Prev by Date: Re: pg_dump: Error message from server: ERROR: compressed data is corrupt
- Next by Date: Re: High Avaliable in the PostgreSQL.
- Previous by thread: Re: Fwd: Out of Memory on Reindex
- Next by thread: Re: Fwd: Out of Memory on Reindex
- Indexes: