Long run functions through RPC
PostgREST
Solved🟢SQLHey! I'm running a function that needs to do some vector search on a 17k rows table, with an index on the embedding column.
My SQL query basically is: give me the 5 most similar entries to <this given vector> in the table, excluding those 3k ids. Running this function in the SQL Editor works fine, but when I use it from my server, using
I tried to set statement timeout higher in SB (2mins) but it fails way before 2 minutes are reached. According to GPT, Supabase also has timeout limitations at RPC level.
Is there any way to increase this timeout ? Or if I ditch RPC for something else, any way to have long runs functions working ?
Thank you!
My SQL query basically is: give me the 5 most similar entries to <this given vector> in the table, excluding those 3k ids. Running this function in the SQL Editor works fine, but when I use it from my server, using
supabase.rpc('my function')I tried to set statement timeout higher in SB (2mins) but it fails way before 2 minutes are reached. According to GPT, Supabase also has timeout limitations at RPC level.
Is there any way to increase this timeout ? Or if I ditch RPC for something else, any way to have long runs functions working ?
Thank you!
