Apparently there is row size limit (in bytes) for B-tree index in Postgresq, which causes index creation fail if string is too big.
How to create partial index which would overcome this ugly limitation? Generally, I have two ideas: A) to store truncated string inside the partial index B) to store only those rows in which the string satisfies the size limit
What is your advice or an example, how to create such partial indexes?