Skip site navigation (1) Skip section navigation (2)

Re: GiST intarray Memory Allocation

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Garrett Heaver <garrett(dot)heaver(at)researchandmarkets(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: GiST intarray Memory Allocation
Date: 2005-09-04 16:08:57
Message-ID: 20050904160856.GB12741@surnet.cl (view raw or flat)
Thread:
Lists: pgsql-bugs
On Sun, Sep 04, 2005 at 04:49:27PM +0100, Garrett Heaver wrote:

> I have a table with circa 5.5Million rows and an int4[] column containing
> about 28 elements each.
> 
> When I try to put a CREATE INDEX name ON table USING gist(column);
> I get the following :
> 
> ERROR:  invalid memory alloc request size 2825271912

Hmm.  Have you tried a plain
SELECT * FROM table?

It sounds like your table may be corrupt.

Another alternative is that the opclass functions are buggy.  If the
table is not corrupt, you could try giving us complete working
instructions to try to reproduce the bug.

-- 
Alvaro Herrera -- Valdivia, Chile         Architect, www.EnterpriseDB.com
"Thou shalt not follow the NULL pointer, for chaos and madness await
thee at its end." (2nd Commandment for C programmers)

In response to

Responses

pgsql-bugs by date

Next:From: Garrett HeaverDate: 2005-09-04 16:14:04
Subject: Re: GiST intarray Memory Allocation
Previous:From: Garrett HeaverDate: 2005-09-04 15:49:27
Subject: GiST intarray Memory Allocation

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group