Skip to content

FACIAL RECOGNITION job runs everyday to process same set of photos #8529

Closed Answered by mertalev
ufizo asked this question in Q&A
Discussion options

You must be logged in to vote

That's weird, you don't have any vector indices. You can run these to make things much faster:

SET vectors.pgvector_compatibility=on;

CREATE INDEX IF NOT EXISTS clip_index ON smart_search
    USING hnsw (embedding vector_cosine_ops)
    WITH (ef_construction = 300, m = 16);

CREATE INDEX IF NOT EXISTS face_index ON asset_faces
    USING hnsw (embedding vector_cosine_ops)
    WITH (ef_construction = 300, m = 16);

Replies: 3 comments 14 replies

Comment options

You must be logged in to vote
0 replies
Comment options

You must be logged in to vote
1 reply
@mertalev
Comment options

Answer selected by ufizo
Comment options

You must be logged in to vote
13 replies
@barrancoguy
Comment options

@mertalev
Comment options

@sorinvasilescu
Comment options

@mertalev
Comment options

@sorinvasilescu
Comment options

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Category
Q&A
Labels
None yet
4 participants
Converted from issue

This discussion was converted from issue #8526 on April 05, 2024 03:39.