Re: index row size exceeds btree maximum, 2713 -

Scott Marlowe <smarlowe@g2switchworks.com> writes:
> On Tue, 2005-07-19 at 05:42, Dennis Bjorklund wrote:
>> You can index text fields, but you can't insert values bigger then
>> BLOCKSIZE/3 when you have an index on that column.]

> Please note that the size limitation is for btree indexes, the most
> common and well tested index types.
> For hash you can have a much larger value, but only direct matching is
> supported.
> I don't know about GiST...

None of the index types support entries larger than BLOCKSIZE-less-a-bit,
so switching to a different index type won't do more than push the
problem out by a factor of about 3.

            regards, tom lane