Performance!
Krassimir Slavchev
krassi at bulinfo.net
Wed Jan 9 05:02:15 PST 2008
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hello,
Kris Kennaway wrote:
> Krassimir Slavchev wrote:
>> -----BEGIN PGP SIGNED MESSAGE-----
>> Hash: SHA1
>>
>> Hello,
>>
>> Here are lock profiling results with select patch applied.
>
> OK, you are doing I/O over TCP. Are you sure you are using TCP on both
> systems? Linux may not be defaulting to TCP transport for local queries.
>
> Add --pgsql-host="" to your sysbench command line to make it communicate
> over a local domain socket, which is much more efficient.
>
> Kris
>
Hmm, Yes linux uses local domain sockets!
Here are results using local domain sockets on FreeBSD too:
#threads #tranzactions/sec
1 728
5 2996
10 5301
20 3931
40 2466
60 1852
80 1424
100 1216
Just to remember:
Linux (2.6.18)
#threads #transactions/sec
1 693
5 3539
10 5789
20 5791
40 5661
60 5517
80 5401
100 5319
I have results using Fedora 8 on the same hardware:
Linux (2.6.23)
#threads #transactions/sec
1 740
5 2675
10 6486
20 6893
40 6623
60 6623
80 6522
100 6417
If we look at the results with up to 10 threads the performance of
FreeBSD is very good.
May be something can be tuned for number of threads > number of CPUs?
Are you interested in lock profiling statistics with more threads than
the number of CPUs?
Best Regards
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (FreeBSD)
iD8DBQFHhMCxxJBWvpalMpkRAvuFAJ4+ab5o4DoLZXrJ3hrr6vbJG9veTgCfdjn5
d8kf8v17QhiYSn20yDgWl3E=
=Tsub
-----END PGP SIGNATURE-----
More information about the freebsd-stable
mailing list