Postgres Issue when an element has a lot of relations.

internetztube / craft-element-relations

Shows all relations of an element.

https://plugins.craftcms.com/element-relations

Other

2 stars 5 forks source link

Postgres Issue when an element has a lot of relations. #12

Closed internetztube closed 3 months ago

internetztube commented 2 years ago

SQLSTATE[54000]: Program limit exceeded: 7 ERROR: index row size 3248 exceeds maximum 2712 for index "idx_ncqxrcfezowfzzbexzbizkgivjmmyonsselc" 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 SQL being executed was: UPDATE "elementrelations" SET "relations"='|elements-start-

internetztube commented 3 months ago

This is fixed with the latest release.