Scott Marlowe <smarlowe@xxxxxxxxxxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
