Trying to use GIST indexes again - Mailing list pgsql-general

From Greg Stark
Subject Trying to use GIST indexes again
Date
Msg-id 87vfg0mfd3.fsf@stark.xeocode.com
Whole thread Raw
Responses Re: Trying to use GIST indexes again  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
List pgsql-general
What does this mean?

test=> create index cache_i_gist_sl on cache using gist (r_id, sl_ids);
ERROR:  index row requires 8216 bytes, maximum size is 8191

Postgres 7.4.2
I have btree_gist and intarray loaded.
r_id is an integer, sl_ids is an int[].

Does it simply mean one of the int arrays is too large? Most of them have 0,
1, or 2, but there are the occasional entries with up to 2,141 elements.

--
greg

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Out of swap space & memory
Next
From: "Jim C. Nasby"
Date:
Subject: Re: Casting timestamp with time zone to varchar automatically