Marc Millas <marc.millas@xxxxxxxxxx> 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
