Re: Memory exhausted in AllocSetReAlloc

From: Thomas Lockhart <lockhart(at)fourpalms(dot)org>
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:26:26
Message-ID: 3BF27F12.C8CBA1B2@fourpalms.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> 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).

You may be running into a per-process limit, which can be adjusted in
the kernel (probably after boot time, but I'm not familiar with the
details on FreeBSD).

- Thomas

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Doug McNaught 2001-11-14 14:35:36 Re: Memory exhausted in AllocSetReAlloc
Previous Message Jean-Michel POURE 2001-11-14 14:12:03 Re: How to store koi8-r (cyrillic) data?