News for hackers. Stuff that matters.
Re:PostgreSQL Indexes: First principles by merb on Friday February 26, 2016 @04:10PM (#11184272)
However mostly it is.

Consider the example with the ID's if he would have an index with all the fields he would need, example he would only need the id and the email he could create a index with them and the query would be faster, that would be a index only scan (https://wiki.postgresql.org/wiki/Index-only_scans)

Re:PostgreSQL Indexes: First principles by wfn on Friday February 26, 2016 @08:07PM (#11185538)
Sure, I guess with index-only scans the picture does shift a bit, right? And quite a few cases are reducible to those, so this can't be ignored.