Hi, Heikki Linnakangas wrote:
Maybe, TPC-C is very write-intensive. I don't know much about RAID stuff, but I think you'd really benefit from a separate WAL drive. You could try turning fsync=off to see if that makes a difference.
Hm.. good idea, I'll try that.
Oh, and how many connections are you using? DBT-2 can be quite sensitive to that. 30 seems to work pretty well for me.
I've been using between 2 and 90, but that made pretty much no difference at all. I'm not getting anything more that some 300 NOTPM.
Regards Markus