Hi!
I’m using pgvector with Supabase (Free tier) to implement semantic search through the Supabase Vector Store node in n8n.
I have a table (documents_en) with just one row, and the following structure:
id bigint primary key, content text, metadata jsonb, embedding vector(1536)
The vector search fails with this error:
Error searching for documents: 57014 canceling statement due to statement timeout null
What I’ve already checked:
pgvector extension is enabled
embedding index created via ivfflat
ANALYZE documents_en; was run
Statement timeout for postgres is 1min (show statement_timeout)
I also tried adding HNSW index — still times out
Table documents_en contains a single row with valid 1536-dim embedding
No RLS (Row Level Security) is active
Tried limit = 4, limit = 1 — same issue
If I run the query manually in SQL Editor, everything works fine
just a couple of lines in the table
Everything was working fine until a certain point, but now it has stopped working on one chain in n8n. All other chains work with one table and this error rarely occurs, but it always occurs on one chain. Why is this? Please advise.