Re: Latest advice on SSD?

2018-04-10 Thread Aaron
. (Some cloud vendors offer SSD as a way to get dedicated local io and bandwidth - so sometimes it helps stablize performance vs. virtualized shared io.) A REASONABLE PERSON SHOULD ASSUME THAT UNBENCHMARKED AND UNRESEARCHED MIGRATION FROM TUNED SPINNING TO SSD WILL SLOW YOU DOWN /Aaron > On Apr

Re: Half billion records in one table? RDS

2017-12-05 Thread Aaron Werman
ce while >requiring low maintenance? >- What about Auto Vacuum? Any suggestion how to optimize it for such a >work load (we will insert and delete millions of rows every day). > > P.S.: We are going to test all this, but if we don't get the performance > we are expecting, all optimization tips from you guys will be really > appreciated. :) > > Thanks > > > > -- Regards, /Aaron