Trying to use GIST indexes again

From: Greg Stark <gsstark(at)mit(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: Trying to use GIST indexes again
Date: 2004-08-03 15:05:28
Message-ID: 87vfg0mfd3.fsf@stark.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marius Andreiana 2004-08-03 16:02:42 Re: NOT IN query takes forever
Previous Message Tom Lane 2004-08-03 14:59:17 Re: NOT IN query takes forever