Marc Millas <marc.millas@mokadb.com> writes:
> I know, its clearly stated in postgres doc about btree," The only
> limitation is that an index entry cannot exceed approximately one-third of
> a page (after TOAST compression, if applicable)."
Yup.
> is there any plan to adress this ?
No. The cost/benefit ratio seems completely untenable.
The usual recommendation is that you shorten long values by hashing
them, eg create a unique index on md5(my_long_column).
regards, tom lane