Indexes on text fields are throwing on large submissions

[max-degterev]

Link to reproduction

No response

Describe the Bug

If you have a text field with an index and try to save a large chunk of text you get this error:

[12:17:18] ERROR (payload): POST /sites/:id/entries
    err: {
      "type": "DatabaseError",
      "message": "index row size 3136 exceeds btree version 4 maximum 2704 for index \"e_texts_value_idx\"",
      "stack":
          error: index row size 3136 exceeds btree version 4 maximum 2704 for index "e_texts_value_idx"
              at /home/node/app/node_modules/pg/lib/client.js:526:17
              at processTicksAndRejections (node:internal/process/task_queues:95:5)
              at /home/node/app/node_modules/src/node-postgres/session.ts:66:19
              at insertArrays (/home/node/app/node_modules/@payloadcms/db-postgres/src/upsertRow/insertArrays.ts:73:22)
              at upsertRow (/home/node/app/node_modules/@payloadcms/db-postgres/src/upsertRow/index.ts:291:5)
              at Object.create (/home/node/app/node_modules/@payloadcms/db-postgres/src/create.ts:17:18)
              at create (/home/node/app/node_modules/payload/src/collections/operations/create.ts:253:15)
              at handler (/endpoints/entries/index.ts:190:23)
      "length": 390,
      "name": "error",
      "severity": "ERROR",
      "code": "54000",
      "detail": "Index row references tuple (40,1) in relation \"e_texts\".",
      "hint": "Values larger than 1/3 of a buffer page cannot be indexed.\nConsider a function index of an MD5 hash of the value, or use full text indexing.",
      "schema": "public",
      "table": "e_texts",
      "constraint": "e_texts_value_idx",
      "file": "nbtutils.c",
      "line": "2675",
      "routine": "_bt_check_third_page"
    }

I don't think there is a way to patch this outside of payload/drizzle. Any chance you could include additional index configuration for this usecase? Atm text field indexes are only working for short content fields.

To Reproduce

Use text field with an index, submit a large chunk of text

Payload Version

latest v2

Adapters and Plugins

No response

[DanRibbens]

This should be possible in @beta since we added afterInitSchema which will be the only way to customize your index.

We don't have a plan to backport that to 2.0 at this time.

[github-actions]

This issue has been automatically locked.
Please open a new issue if this issue persists with any additional detail.