Re: [BUGS] GiST intarray Memory Allocation

2005-09-04 Thread Tom Lane
"Garrett Heaver" <[EMAIL PROTECTED]> writes: > Just to confirm also > I dumped the database and restored to a Suse Linux 9.3 Box > Same problem occurs (different alloc request size though) > I can forward a dump of the database if required Please (unless you've already heard from Oleg or Teodor, w

Re: [BUGS] GiST intarray Memory Allocation

2005-09-04 Thread Garrett Heaver
Garrett Heaver Sent: 04 September 2005 17:14 To: 'Alvaro Herrera' Cc: [email protected] Subject: Re: [BUGS] GiST intarray Memory Allocation Performed full table select - worked perfectly I can give you a dump of the table if that will help Thanks Garrett -Original Message

Re: [BUGS] GiST intarray Memory Allocation

2005-09-04 Thread Garrett Heaver
intarray Memory Allocation 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 followi

Re: [BUGS] GiST intarray Memory Allocation

2005-09-04 Thread Alvaro Herrera
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 re

[BUGS] GiST intarray Memory Allocation

2005-09-04 Thread Garrett Heaver
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 mem