4 ms·
This is true of MySQL (which the guide uses), but not necessarily of other databases such as Postgres.
by iaabtpbtpnn 5y ago
This is true of MySQL (which the guide uses), but not necessarily of other databases such as Postgres.
- srcreigh 5y agoYou're right. Postgres doesn't give any control over primary data locality. That might cause querying 1 row a bit faster in Postgres (no log(N) traversal of the primary B-tree index) but picking out N rows could be a lot slower. https://www.postgresql.org/docs/13/indexes-index-only-scans.html https://www.postgresql.org/docs/13/indexes-index-only-scans....