B-Tree index size limit with long translated text

[Gruenfischer (Jakob Fischer)]

Hi,

Tryton version: 8.0
Database: PostgreSQL

When saving a longer translatable text, an HTML marketing email, PostgreSQL raises:

psycopg.errors.ProgramLimitExceeded:
index row size 2768 exceeds btree maximum 2704

The error occurs while writing the translated value to ir_translation.

Before assuming this is a bug, I would like to check whether I am missing a recommended configuration option or database/index setting for handling larger translated Text values.

Reproduction:

1. Use a field with translate=True in Marketing E-Mail.
2. Store a longer HTML/text value.
3. Save the record.
4. PostgreSQL rejects the write with the B-Tree index row size error.

Is this expected with the default Tryton 8.0 schema, or is there a configuration/migration step I may have missed?

Regards, Jakob

[ced (Cédric Krier)]

See Add size limit on translated fields (#12713) · Issues · Tryton / Tryton · GitLab and Use report to store marketing automation Activity's content (#13436) · Issues · Tryton / Tryton · GitLab

[pokoli (Sergi Almacellas Abellana)]

It can be solved by using a btree_gin index which has no size limit but before going futher I will recomend reading this topic which contains all the relevant information:

Indexing crash on migration 6.8

I do not think it is really usable to have large Text field translatable. With Support btree_gin extension (#12480) · Issues · Tryton / Tryton · GitLab GIN index could be used for such case which has no limit.