SupabaseS
Supabase•2y ago
Julian IncrEdelman

Create Index on PGVector times out

I created and populated embeddings. It's not small (~30MB table; 114k rows). I want to add an index to speed up my seq scan queries. That is timing out via "supabase db push"

ERROR: canceling statement due to statement timeout (SQLSTATE 57014)
At statement 0: CREATE INDEX index_idx ON public.embeddings_table USING hnsw (embedding vector_l2_ops)


I couldn't find any other reference to this issue.
Was this page helpful?