Is using range on RPC recommended?
Lets say I have a very large table and I am using a database function to query it like so:
Would this construct the result of the whole function first before returning the ranged part from it? Because one of my background tasks keeps failing after the range gets too high with
How can I improve this? This is probably less of a supabase question but more related to postgres.
Would this construct the result of the whole function first before returning the ranged part from it? Because one of my background tasks keeps failing after the range gets too high with
canceling statement due to statement timeoutHow can I improve this? This is probably less of a supabase question but more related to postgres.
