News for hackers. Stuff that matters.
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?
Re:Why we lost Uber as a user by kod on Tuesday August 02, 2016 @10:28AM (#12210182)
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.