Hacker Newsnew | past | comments | ask | show | jobs | submitlogin
SELECT * can be very bad, Postgres 9... (jivesoftware.com)
11 points by craigkerstiens on Jan 28, 2013 | hide | past | favorite | 1 comment


I understand that this is about the use of index-only scans more than anything, but I think the example is a bad one, because surely you would do a COUNT rather than a SELECT to get a follower count. Can't think of many situations where you'd want to load all of the 'follower' data at once, especially as you'd likely use pagination and lots of caching for actually displaying users anyway.




Consider applying for YC's Winter 2026 batch! Applications are open till Nov 10

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: