Bug Description

Cannot create bm25 index on table with ~500 partitions

Environment

• PostgreSQL version: (e.g., 17.7)
• pg_textsearch version: 0.3.0

Steps to Reproduce

Attempt to create a bm25 index on table slack.message on tiger-slack (q8payp6mmi/gm4dpivruv) instance using following query:

create index message_text_bm25_idx on slack.message using bm25(text) with (text_config='english');

Slack me for connection string.

Expected Behavior

Index created without errors.

Actual Behavior

Error happened:

Error: too many LWLocks taken
Error Code: XX000

Additional Context

Any other context about the problem (logs, screenshots, etc.).