Index Tuning
Write Throughput
Several settings can be used to tune the throughput of
Since many write operations can be running concurrently, this value should be raised more conservatively than
INSERT/UPDATE/COPY statements to the BM25 index.
Work Memory
work_mem controls how much memory to allocate to a single INSERT/UPDATE/COPY statement. Each statement that writes to a BM25 index is required to have at least 15MB memory. If
work_mem is below 15MB, it will be ignored and 15MB will be used.
If your typical update patterns are single-row atomic INSERTs or UPDATEs, then a value of 15MB can prevent unnecessary memory from being allocated. For bulk inserts
and updates, a larger value is better.
maintenance_work_mem.