pgvector.git / summary / log / commit / refs

commit    8765e79ec2e2e59a524171ae2aa622d8a18789cd
Author:   Andrew Kane <andrew@ankane.org>
Date:     Thu Jan 25 21:32:35 2024 +0000

    Added note about max_parallel_maintenance_workers for HNSW [skip ci]


 README.md | 8 ++++++++
 1 file changed, 8 insertions(+)

diff --git a/README.md b/README.md
index c6d02e77..d2e6f360 100644
--- a/README.md
+++ b/README.md
@@ -264,6 +264,14 @@ HINT:  Increase maintenance_work_mem to speed up builds.
 
 Note: Do not set `maintenance_work_mem` so high that it exhausts the memory on the server
 
+Starting with 0.6.0 [unreleased], you can also speed up index creation by increasing the number of parallel workers (2 by default)
+
+```sql
+SET max_parallel_maintenance_workers = 7; -- plus leader
+```
+
+For a large number of workers, you may also need to increase `max_parallel_workers` (8 by default)
+
 ### Indexing Progress
 
 Check [indexing progress](https://www.postgresql.org/docs/current/progress-reporting.html#CREATE-INDEX-PROGRESS-REPORTING) with Postgres 12+


[parent: 7fff6cd13831]