Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

Oddly enough, for a big enough update, postgres sometimes will do the math and decide that scanning the whole table is faster than scanning the index and then scanning a certain fraction of the table (considering also that it has to rewrite the entire page if any row in the page is updated)


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

Search: