canceling statement due to statement timeout
according to https://supabase.com/docs/guides/database/timeouts
set statement_timeout to 60000; -- 1 minute in milliseconds
would change this
i tried set statement_timeout to 300000; -- 5 minute in milliseconds
Is there a limit to this or something. It doesnt seem to be working. I have a lot of math in func. Works in small inc but want to loop through many but times out with larger group. Do I need to try one of those upgrades with more cores or whatever (idk what that really means)
set statement_timeout to 60000; -- 1 minute in milliseconds
would change this
i tried set statement_timeout to 300000; -- 5 minute in milliseconds
Is there a limit to this or something. It doesnt seem to be working. I have a lot of math in func. Works in small inc but want to loop through many but times out with larger group. Do I need to try one of those upgrades with more cores or whatever (idk what that really means)
