Re:PostgREST – Serve a RESTful API from Any Postgres Database
by yladiz on Thursday December 29, 2022 @05:21PM
(#34178848)
I see. How do you determine when to kill the query before running it then? Of course you could do “if the process is running longer than X seconds kill and returns NNN status code” but that feels somewhat wasteful if you can be smarter when calculating the possible cost.
[ Parent
| on HN ]
Re:PostgREST – Serve a RESTful API from Any Postgres Database
by zX41ZdbW on Saturday December 31, 2022 @11:49AM
(#34198185)
The cost can be calculated, but not always.
Example 1:
SELECT ... FROM table WHERE key BETWEEN c1 AND c2
- here we can get the number of records and bytes to scan before even starting the query.Example 2:
SELECT ... FROM table WHERE key = (SELECT ...)
- here we cannot know how many records will be scanned until we will finish the subquery.Maybe some estimations can be applied... but we don't do that.