Every story and comment from the Hacker News API, in a layout borrowed from 2001.
A comment on PostgREST – Serve a RESTful API from Any Postgres Database. Parent comment
Example 1:
SELECT ... FROM table WHERE key BETWEEN c1 AND c2
Example 2:
SELECT ... FROM table WHERE key = (SELECT ...)
Maybe some estimations can be applied... but we don't do that.
There are no comments on this comment yet.
Example 1:
- here we can get the number of records and bytes to scan before even starting the query.Example 2:
- 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.