Postgres Crash with

[Moosheimer]

Bug Description

Using:
CREATE INDEX content_search_idx ON content USING bm25(content) WITH (text_config='english');
on a table with 3 Mio. ::TEXT columns. All columns are very large. The maximum length is, for example, 3005897.

Postgres crashed during the first run. During the second run, Ubuntu 22.04 crashed and restarted.

Environment

• PostgreSQL version: PostgreSQL 18.2 (Ubuntu 18.2-1.pgdg22.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 11.4.0-1ubuntu1~22.04.2) 11.4.0, 64-bit
• pg_textsearch version: 0.5.1
• Operating system: Ubuntu 22.04.5 LTS

Steps to Reproduce

1. Create a table with several million entries.
   One column is of type TEXT, each with very large content.
2. Then create an index on the column of type Text.

CREATE INDEX content_search_idx ON content USING bm25(content) WITH (text_config='english');

Expected Behavior

Should run without crash :)

Actual Behavior

Postgres crashed.

-- Error output here
2026-02-20 20:03:31.693 CET [253805] XXXX@XXXX STATEMENT:  CREATE INDEX content_search_idx ON content USING bm25(content) WITH (text_config='english');
2026-02-20 20:03:31.696 CET [253805] XXXX@XXXX FATAL:  connection to client lost
2026-02-20 20:03:31.696 CET [253805] XXXX@XXXX STATEMENT:  CREATE INDEX content_search_idx ON content USING bm25(content) WITH (text_config='english');
2026-02-20 20:03:31.697 CET [268086] FATAL:  terminating background worker "parallel worker" due to administrator command
2026-02-20 20:03:31.697 CET [268085] FATAL:  terminating background worker "parallel worker" due to administrator command
2026-02-20 20:03:31.697 CET [268087] FATAL:  terminating background worker "parallel worker" due to administrator command
2026-02-20 20:03:31.697 CET [268088] FATAL:  terminating background worker "parallel worker" due to administrator command
2026-02-20 20:03:33.153 CET [2915] LOG:  background worker "parallel worker" (PID 268088) exited with exit code 1
2026-02-20 20:03:33.161 CET [2915] LOG:  background worker "parallel worker" (PID 268085) exited with exit code 1
2026-02-20 20:03:33.190 CET [2915] LOG:  background worker "parallel worker" (PID 268087) exited with exit code 1
2026-02-20 20:03:33.204 CET [2915] LOG:  background worker "parallel worker" (PID 268086) exited with exit code 1
2026-02-20 20:08:17.205 CET [3156] LOG:  checkpoint starting: time

-> I have no idea what "due to administrator command" means. I didn't do anything.

Additional Context

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

[tjgreen42]

I can't immediately repro based on the information from the report, but my guess is that this will get fixed with #231. That PR is targeting large-scale indexing (MS-MARCO v2 uncovers some sloppy memory management) -- the docs are smaller than the ones mentioned in this report, but I bet the OOM is for the same reasons.

[Moosheimer]

@tjgreen42
Can confirm that it now works with v.0.6.0.
#231 seems to have fixed the problem.