SSDs are not faster for sequential IO as I know. That's why (with BBU or synchronious_commit=off) I prefer to have logs on regular HDDs.
Best reag 2012/11/30 Willem Leenen <willem_lee...@hotmail.com> > > Actually, what's the point in putting logs to ssd? SSDs are good for > random access and logs are accessed sequentially. I'd put table spaces on > ssd and leave logs on hdd > 30 лист. 2012 04:33, "Niels Kristian Schjødt" < > nielskrist...@autouncle.com> напис. > Because SSD's are considered faster. Then you have to put the most > phyisical IO intensive operations on SSD. For the majority of databases, > these are the logfiles. But you should investigate where the optimum is for > your situation. > > -- Best regards, Vitalii Tymchyshyn
