Every story and comment from the Hacker News API, in a layout borrowed from 2001.
A comment on Postgres Just Cracked the Top Fastest Databases for Analytics. Parent comment
Analytics generally means a full table scan or similar for each query, because you're e.g. taking an average of every value.
You're talking about indexes which are to optimize retrieving a handful (or few thousand) of rows.
There are no comments on this comment yet.
Analytics generally means a full table scan or similar for each query, because you're e.g. taking an average of every value.
You're talking about indexes which are to optimize retrieving a handful (or few thousand) of rows.