Re: Memory exhausted in AllocSetReAlloc

From: Doug McNaught <doug(at)wireboard(dot)com>
To: Eric Cholet <cholet(at)logilune(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Memory exhausted in AllocSetReAlloc
Date: 2001-11-14 14:35:36
Message-ID: m3n11pfmiv.fsf@belphigor.mcnaught.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Eric Cholet <cholet(at)logilune(dot)com> writes:

> Using CREATE INDEX on a large table (>70 million rows)
> results in the following error:
>
> ERROR: Memory exhausted in AllocSetReAlloc(134217728)
>
> (134217728 is exactly 128 megabytes).
>
> The box has 2Gigs of RAM.

Have you double checked to make sure the ulimits for postmaster are
large enough?

-Doug
--
Let us cross over the river, and rest under the shade of the trees.
--T. J. Jackson, 1863

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrew G. Hammond 2001-11-14 15:03:51 transitioning from MS SQL Server to Postgres
Previous Message Thomas Lockhart 2001-11-14 14:26:26 Re: Memory exhausted in AllocSetReAlloc