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

GiST intarray Memory Allocation

From: "Garrett Heaver" <garrett(dot)heaver(at)researchandmarkets(dot)com>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: GiST intarray Memory Allocation
Date: 2005-09-04 15:49:27
Message-ID: MAILqE1L7HRjGLinwB300006946@mail.researchandmarkets.com (view raw or flat)
Thread:
Lists: pgsql-bugs
Hi All

 

Platform: Win32 (XP SP2)

PG: 8.0.3 (default config file)

 

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

 

Any help appreciated or if you need more info just ask.

 

Thanks

Garrett

Responses

pgsql-bugs by date

Next:From: Alvaro HerreraDate: 2005-09-04 16:08:57
Subject: Re: GiST intarray Memory Allocation
Previous:From: Michael FuhrDate: 2005-09-03 20:57:12
Subject: Re: extra columns in intermediate nodes not being removed by top level of executor

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