Re: postgresql-performance using sysbench

I had (allready) saved the thread in my mail-account so I could look
it up before I started testing. :-) So I compiled postgresql with the
option WITH_THREADSAFE=true and used sysbench with --pgsql-host="" .
As pointed out by Ivan my test also involved r/w whereas the thread
you (probably) mention at
http://groups.google.com/group/mailing.freebsd.stable/browse_thread/thread/e224cd4f76e9ec2d
is a read-only test.

I forgot to mention in my first post that I'm using ULE. The p800
controller has a (factory set) 25/75 read/write cache ratio.


I am still going through my own testing. One thing I noticed, on a
4G RAM machine (still waiting for the RAM to test with 8G), the disks
are not that busy. It seems to be the CPU that is the bottleneck on
FreeBSD. I tried the test with 900,000 rows instead.

procs memory page disks faults cpu
r b w avm fre flt re pi po fr sr ad5
da0 in sy cs us sy id
38 1 0 271024 3439656 6329 0 0 0 4 0 0 1703 1709
120725 41505 44 18 37
0 38 0 271024 3438860 9590 0 0 0 8 0 0 1932 1938
183844 47958 70 28 3
6 33 0 271024 3438120 7814 0 0 0 0 0 0 1823 1827
169969 44914 62 25 13
39 0 0 271024 3437960 1530 0 0 0 0 0 0 994 998 36521
14927 13 8 79
38 1 0 271024 3437244 7374 0 0 0 0 0 0 2724 2731
173493 51821 71 20 9
0 39 0 271024 3436620 4773 0 0 0 8 0 0 2727 2734
125699 39962 47 20 33
37 1 0 271024 3435836 6884 0 0 0 8 0 0 2796 2804
177453 58430 70 26 4

I am also using ULE, pgsql with WITH_THREADSAFE=true and not using
TCP to connect. How busy were your disks in your testing ?

Approx. 15-25 MB with spikes at approx. 45-50 MB. Context-swithces
were sometimes 140.000 with 20-30 clients (systat -vmstat 1).

--
regards
Claus

When lenity and cruelty play for a kingdom,
the gentlest gamester is the soonest winner.

Shakespeare
_______________________________________________
freebsd-performance@xxxxxxxxxxx mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-performance
To unsubscribe, send any mail to "freebsd-performance-unsubscribe@xxxxxxxxxxx"

Relevant Pages

  • Re: postgresql-performance using sysbench
    ... One thing I noticed, on a 4G RAM machine, the disks are not that busy. ... It seems to be the CPU that is the bottleneck on FreeBSD. ...
    (freebsd-performance)
  • Re: postgresql-performance using sysbench
    ... I forgot to mention in my first post that I'm using ULE. ... One thing I noticed, on a 4G RAM machine, the disks are not that busy. ...
    (freebsd-performance)
  • Re: Very slow copying data from RAID 1 array.
    ... The backup segments total approx 70Gb. ... At the moment it need not be the disks themselves. ... I cant see anywhere to check or alter the transfer mode to the RAID array. ... controller and use a Knoppix CD only Linux to get their SMART ...
    (comp.sys.ibm.pc.hardware.storage)
  • Re: Increase disk cache and buffers in 5.3?
    ... > Run systat -v on the server and you'll soon see how hard you are ... ad0 79% busy ... On another freebsd box with a raid controller I am seeing: ... RAID with SCSI-3 disks. ...
    (comp.unix.bsd.freebsd.misc)
  • Re: performance hints (6.2)
    ... it shows disks as being 102% busy ... gstat's "busy" statistic is entirely meaningless for this context ... Your data showed your CPU doing almost no work, so I/O is definitely ...
    (freebsd-questions)