INSERT INTO items (embedding)VALUES ('[1,2,3]'), ('[4,5,6]');

Or load vectors in bulk using`COPY` ([example](https://github.com/pgvector/pgvector-python/blob/master/examples/bulk_loading.py))

Or load vectors in bulk using`COPY` ([example](https://github.com/pgvector/pgvector-python/blob/master/examples/loading/example.py))

COPY items (embedding)FROM STDIN WITH (FORMAT BINARY);

Use the`bit` type to store binary vectors ([example](https://github.com/pgvector/pgvector-python/blob/master/examples/hash_image_search.py))

Use the`bit` type to store binary vectors ([example](https://github.com/pgvector/pgvector-python/blob/master/examples/imagehash/example.py))

CREATETABLEitems (idbigserialPRIMARY KEY, embeddingbit(3));

WHERE textsearch @@ queryORDER BY ts_rank_cd(textsearch, query)DESCLIMIT5;

You can use[Reciprocal Rank Fusion](https://github.com/pgvector/pgvector-python/blob/master/examples/hybrid_search_rrf.py) or a[cross-encoder](https://github.com/pgvector/pgvector-python/blob/master/examples/hybrid_search.py) to combine results.

You can use[Reciprocal Rank Fusion](https://github.com/pgvector/pgvector-python/blob/master/examples/hybrid_search/rrf.py) or a[cross-encoder](https://github.com/pgvector/pgvector-python/blob/master/examples/hybrid_search/cross_encoder.py) to combine results.

Use`COPY` for bulk loading data ([example](https://github.com/pgvector/pgvector-python/blob/master/examples/bulk_loading.py)).

Use`COPY` for bulk loading data ([example](https://github.com/pgvector/pgvector-python/blob/master/examples/loading/example.py)).

COPY items (embedding)FROM STDIN WITH (FORMAT BINARY);

Scale vertically by increasing memory, CPU, and storage on a single instance. Use existing tools to[tune parameters](#tuning) and[monitor performance](#monitoring).

Scale horizontally with[replicas](https://www.postgresql.org/docs/current/hot-standby.html), or use[Citus](https://github.com/citusdata/citus) or another approach for sharding ([example](https://github.com/pgvector/pgvector-python/blob/master/examples/citus.py)).

Scale horizontally with[replicas](https://www.postgresql.org/docs/current/hot-standby.html), or use[Citus](https://github.com/citusdata/citus) or another approach for sharding ([example](https://github.com/pgvector/pgvector-python/blob/master/examples/citus/example.py)).