Create index with HNSW silently fails
I was trying to create vector embeddings index with HNSW via the SQL editor on a table with ~100.000 OpenAI embeddings. After running the
I understand that this might be an issue with memory usage, but what's the recommended way to debug this? Will adjusting the
I tried running the same command on a much smaller table and it worked.
Appreciate your help!
create index command, I was checking the progress: the tuples_total remained on zero as it's on building index step, with number of tuples_done increasing for a few seconds until it finished, but no index was created.I understand that this might be an issue with memory usage, but what's the recommended way to debug this? Will adjusting the
ef_construction or m help at all in this case?I tried running the same command on a much smaller table and it worked.
Appreciate your help!
