Re: dbt2 NOTPM numbers

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux