Re: Memory exhausted in AllocSetReAlloc - Mailing list pgsql-general

From Doug McNaught
Subject Re: Memory exhausted in AllocSetReAlloc
Date
Msg-id m3n11pfmiv.fsf@belphigor.mcnaught.org
Whole thread Raw
In response to Memory exhausted in AllocSetReAlloc  (Eric Cholet <cholet@logilune.com>)
Responses Re: Memory exhausted in AllocSetReAlloc
List pgsql-general
Eric Cholet <cholet@logilune.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

pgsql-general by date:

Previous
From: Thomas Lockhart
Date:
Subject: Re: Memory exhausted in AllocSetReAlloc
Next
From: Janning Vygen
Date:
Subject: Re: psql -f backup.out || file too big