Bug Description

After creating an index over ~51M rows of historical reddit posts (~9.2G heap) I was left with a 29G index where all queries fail with:

# select * from reddit_body where body <@> 'green beer' < 1.0;
ERROR:  invalid memory alloc request size 1874788361

Here's gist of my whole session: https://gist.github.com/eeeebbbbrrrr/902e0ca6aaf533abf0ff0e47c68d26e6

Note the end of the gist where I restarted postgres

I can't share the data (too big and not even clear I should have the data!), but I wanted to report the problems I ran into in quickly evaluating pg_textsearch.

Environment

• PostgreSQL version: 18.1, compiled from git from REL_18_STABLE
• pg_textsearch version: 6c343db
• Operating system: Ubuntu on x86_64

Steps to Reproduce

Hopefully the above linked gist is enough. If not, let me know.