Re:Why we lost Uber as a user
by ec109685 on Tuesday August 02, 2016 @12:46AM
(#12207882)
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?
[ Parent
| on HN ]
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.