Re: index row size exceeds btree maximum, 2713 -

On Tue, 2005-07-19 at 05:42, Dennis Bjorklund wrote:
> On Mon, 18 Jul 2005, Jaime Casanova wrote:
>
> > I don't think you could create indexes on text fields... there are
> > other type of indexes for that... tsearch2 for example
>
> 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...