pgvector.git / summary / log / commit / refs
commit cc9e6a67783092ae2e8b1b1ade552e547bef8934
Author: Andrew Kane <andrew@ankane.org>
Date: Fri Jan 19 05:57:38 2024 +0000
Added section on max_parallel_maintenance_workers [skip ci]
README.md | 10 ++++++++++
1 file changed, 10 insertions(+)
diff --git a/README.md b/README.md
index 3218634c..31070a44 100644
--- a/README.md
+++ b/README.md
@@ -304,6 +304,16 @@ SELECT ...
COMMIT;
```
+### Index Build Time
+
+Speed up index creation on large tables 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: 8f1b669c4f00]