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