Postgres Pro
Downloads
Home   >   mailing lists

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

From Thomas Lockhart
Subject Re: Memory exhausted in AllocSetReAlloc
Date
Msg-id 3BF27F12.C8CBA1B2@fourpalms.org
Whole thread Raw
In response to Memory exhausted in AllocSetReAlloc  (Eric Cholet <cholet@logilune.com>)
List pgsql-general
Tree view 
> 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

pgsql-general by date:

Previous
From: Jean-Michel POURE
Date:
Subject: Re: How to store koi8-r (cyrillic) data?
Next
From: Doug McNaught
Date:
Subject: Re: Memory exhausted in AllocSetReAlloc