2 ms·
By extrapolation writes are IO bound you don't need crazy expensive things to get to the needed number of IOPS Intel 750 is 230,000 random writes @ $320 per PCI
by qaq 10y ago
By extrapolation writes are IO bound you don't need crazy expensive things to get to the needed number of IOPS Intel 750 is 230,000 random writes @ $320 per PCI-E SSD. 9 drive
config is over 2,000,000 IOPS for less than 3K.
- g0del_was_wr0ng 10y agoYeah it's a bit more complex than that... The disk "IOPS" number on the box doesn't translate 1:1 or even linearly to number of committed durable transactions per second. You should try this with postgres and see how it goes.
- qaq 10y agoIf you land me 30K for the hardware I would be glad to do it :). For writing WAL it scales reasonably close to linear