apparently there row size limit (in bytes) b-tree index in postgresq, causes index creation fail if string big.
how create partial index overcome ugly limitation? generally, have 2 ideas: a) store truncated string inside partial index b) store rows in string satisfies size limit
what advice or example, how create such partial indexes?
Comments
Post a Comment