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

500 updates is nothing for a modern database. 10k's of updates is no sweat on modern hardware. What is so scary about this load?


Multiply the number of updates times the number of indexes. Then consider that with such a small table, there's going to be contention for the same rows. Updates actually create new rows, so vacuum needs to be able to remove older, no-longer-visible versions of the row. But vacuum can't keep up, because at any given time many versions of the row are potentially visible.




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

Search: