Send feedback
Create indexes and query vectors
Stay organized with collections
Save and categorize content based on your preferences.
This document shows you how to use stored embeddings to generate indexes and query
embeddings. For more information about storing embedding, see
Store vector embeddings .
You can create ScaNN
, IVF
, IVFFlat
, and HNSW
indexes with AlloyDB.
Before you begin
Before you can start creating indexes, you must complete the following
prerequisites.
Embedding vectors are added to a table in your
AlloyDB database.
The pgvector
extension, version 0.5.0
or later, extended by Google for
AlloyDB is installed.
CREATE EXTENSION IF NOT EXISTS vector;
To generate ScaNN
indexes, install the alloydb_scann
extension in addition
to the pgvector
extension.
CREATE EXTENSION IF NOT EXISTS alloydb_scann;
Note: The alloydb_scann
extension can be used with PostgreSQL 14 and 15 compatible databases.
Create an index
You can create one of the following index types for tables in your database.
Note: As the index names are shared across the database, create an index name unique to
each table in your database.
ScaNN
IVF
IVFFlat
HNSW
What's next
Send feedback
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License , and code samples are licensed under the Apache 2.0 License . For details, see the Google Developers Site Policies . Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2024-10-02 UTC.
[{
"type": "thumb-down",
"id": "hardToUnderstand",
"label":"Hard to understand"
},{
"type": "thumb-down",
"id": "incorrectInformationOrSampleCode",
"label":"Incorrect information or sample code"
},{
"type": "thumb-down",
"id": "missingTheInformationSamplesINeed",
"label":"Missing the information/samples I need"
},{
"type": "thumb-down",
"id": "otherDown",
"label":"Other"
}]
[{
"type": "thumb-up",
"id": "easyToUnderstand",
"label":"Easy to understand"
},{
"type": "thumb-up",
"id": "solvedMyProblem",
"label":"Solved my problem"
},{
"type": "thumb-up",
"id": "otherUp",
"label":"Other"
}]
Need to tell us more?
{"lastModified": "Last updated 2024-10-02 UTC."}
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2024-10-02 UTC."]]