Hi
I have installed postgres 8.4.4 (libxml and plperl)on a Sun Microsystems sun4u Sun Fire 880 with:
- 4 700Mhz processors
- 8 Gb Ram
- System 9 operSolaris
- 64-bit sparcv9 Applications
- 32-bit sparc Applications
- SCSI-3. Discs do not have any arrangement
It was compiled with the sun-studio (flag-bit X05 and 32 bits ....) ... i follow the recommendations from:
http://www.postgresql.org/docs/8.4/static/installation-platform-notes.html # INSTALLATION-NOTES-SOLARIS
Also I have installed postgres (8.4.2) on a PC (Dell Optiplex 960) with the next characteristics:
- 3 Gb ram
- 1 processor of 3.2 Ghz Dual Core
- A hard SATAS
- 06/02/1928 Linux (gentoo)
We design some performance tests (special for my application); this test was executed with pgbench:
pgbench -c 5 -T 600 -n -U aeedc -f test.sql aeespc
The results was the next:
on pc :
Thu July 29 15:50:02 CDT 2010
transaction type: Custom query
scaling factor: 1
query mode: simple
number of clients: 5
duration: 120 s
Actually number of Transactions processed: 159
tps = 1.302670 (Including Establishing connections)
tps = 1.302746 (excluding Establishing connections)
Thu July 29 15:52:04 CDT 2010
on Solaris:
Mon July 26 18:41:58 CDT 2010
transaction type: Custom query
scaling factor: 1
query mode: simple
number of clients: 5
duration: 120 s
Actually number of Transactions processed: 85
tps = 0.668752 (Including Establishing connections)
tps = 0.669172 (excluding Establishing connections)
Mon July 26 18:44:05 CDT 2010
As observed, is much slower solaris.
I also see the difference in disk access. For example iostat throws in the pc (filter some columns)
device r/s w/s rKB/s wKB/s await %util
sda 0.12 3.62 8.24 45.85 6.06 0.16
sda 0 2.2 0 126.4 0.64 0.08
sda 0 0.8 0 8 0 0
sda 0 1.6 0 31.2 0.12 0.02
sda 0 1.2 0 8.8 0.17 0.02
sda 0 1.8 0 36 0.11 0.02
sda 0 1 0 5.6 0.6 0.06
and on Solaris:
r/s w/s kr/s kw/s wait wsvc_t asvc_t %w %b
c1t0d0 0.1 2.8 2.5 25.3 0.1 27.8 22.8 0 2
c1t0d0 0 4.8 0 36.8 0 0 5.8 0 3
c1t0d0 0 10.8 0 92.8 0 0 8 0 6
c1t0d0 0 12.2 0 97.6 1.2 99.8 77.6 5 7
it is also slower solaris ...
I made the following "tunnings" in solaris without managing to improve the performance:
http://blogs.sun.com/jkshah/entry/best_practices_with_postgresql_8
http://archives.postgresql.org/pgsql-performance/2006-02/msg00190.php
http://vnull.pcnet.com.pl/dl/postgresql/pgsol_best_practices.pdf
My questions
- are there another way to improve the performance of solaris? where can i
read more?
- the PC (with linux) have better performance than SUN (solaris).... therefore
never going to get better performance ... what do you think about it?
Greetings and thanks in advance.
