pgvector.git / summary / log / commit / refs

commit    b125b2debb7ab5d744273a89f1edfffdfd9bafa9
Author:   Andrew Kane <andrew@ankane.org>
Date:     Wed Oct 13 20:56:03 2021 +0000

    Added section on performance [skip ci]


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

diff --git a/README.md b/README.md
index 03789f5f..3241ade4 100644
--- a/README.md
+++ b/README.md
@@ -128,6 +128,20 @@ CREATE INDEX ON table USING ivfflat (column) WHERE (other_column = 123);
 
 To index many different values of `other_column`, consider [partitioning](https://www.postgresql.org/docs/current/ddl-partitioning.html) on `other_column`.
 
+## Performance
+
+To speed up queries without an index, increase `max_parallel_workers_per_gather`.
+
+```sql
+SET max_parallel_workers_per_gather = 4;
+```
+
+To speed up queries with an index, increase the number of inverted lists.
+
+```sql
+CREATE INDEX ON table USING ivfflat (column) WITH (lists = 1000);
+```
+
 ## Reference
 
 ### Vector Type


[parent: 3d7186a17ca0]