@@ -463,15 +463,13 @@ Starting with 0.8.0, you can enable [iterative index scans](#iterative-index-sca
463
463
SET hnsw .iterative_scan = strict_order;
464
464
```
465
465
466
- You can also create separate approximate indexes for each condition value (or groups of values).
467
-
468
- If filtering by a few distinct values, use[ partial indexing] ( https://www.postgresql.org/docs/current/indexes-partial.html ) .
466
+ If filtering by only a few distinct values, consider[ partial indexing] ( https://www.postgresql.org/docs/current/indexes-partial.html ) .
469
467
470
468
``` sql
471
469
CREATE INDEX ON items USING hnsw (embedding vector_l2_ops)WHERE (category_id= 123 );
472
470
```
473
471
474
- If filtering by many different values,use [ partitioning] ( https://www.postgresql.org/docs/current/ddl-partitioning.html ) .
472
+ If filtering by many different values,consider [ partitioning] ( https://www.postgresql.org/docs/current/ddl-partitioning.html ) .
475
473
476
474
``` sql
477
475
CREATE TABLE items (embedding vector(3 ), category_idint ) PARTITION BY LIST(category_id);