indexing - Postgresql BTREE index row size limitation -


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

Popular posts from this blog

resizing Telegram inline keyboard -

command line - How can a Python program background itself? -

php - "cURL error 28: Resolving timed out" on Wordpress on Azure App Service on Linux -