Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)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