pgvector.git / summary / log / commit / refs
commit ceddbac6bfa2cbdd57ffeb201cf3bd280e043945
Author: Andrew Kane <andrew@ankane.org>
Date: Sun May 28 18:36:36 2023 +0000
Improved example [skip ci]
README.md | 3 ++-
1 file changed, 2 insertions(+), 1 deletion(-)
diff --git a/README.md b/README.md
index 34735b8e..d10d750a 100644
--- a/README.md
+++ b/README.md
@@ -240,7 +240,8 @@ CREATE INDEX ON items (category_id);
Or a [partial index](https://www.postgresql.org/docs/current/indexes-partial.html) on the vector column for approximate search
```sql
-CREATE INDEX ON items USING ivfflat (embedding vector_l2_ops) WITH (lists = 100) WHERE (category_id = 123);
+CREATE INDEX ON items USING ivfflat (embedding vector_l2_ops) WITH (lists = 100)
+ WHERE (category_id = 123);
```
Use [partitioning](https://www.postgresql.org/docs/current/ddl-partitioning.html) for approximate search on many different values of the `WHERE` columns
[parent: 0deb44345846]