Re: Performance and doing USENET style threaded messages

Lincoln Yeoh <lyeoh@pop.jaring.my> writes:
> What is the recommended max indexable text length in Postgresql 7.0?

btree indexes have a hard limit at 1/3rd of a block --- it works out
to be exactly 2700 bytes for 8K blocks.  Not sure whether performance
drops off before that.

			regards, tom lane