PostgreSQL Index Row Size Limitations And Alternatives
PostgreSQL's B-tree index limit: 2704 bytes. Migrating to YugabyteDB resolves this issue with its Log-Structured Merge-Tree, allowing larger index entries.
Yesterday at the PostgreSQL Meetup in Suisse Romande, Lucy Linder discussed exciting challenges related to migrating 7000 applications from PostgreSQL 13 to 15. She highlighted an issue regarding the following error during pg_restore:
ERROR: index row size 3056 exceeds btree version 4 maximum 2704 for index
HINT: Values larger than 1/3 of a buffer page cannot be indexed. Consider a function index of an MD5 hash of the value, or use full-text indexing.
The slide mentions "RDS Only" because the issue wasn't replicated when importing it into vanilla PostgreSQL. However,...