solaris slow

From: Felipe de Jesús Molina Bravo <fjmolinabravo(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: solaris slow
Date: 2010-08-02 14:35:42
Message-ID: AANLkTimkA=g=zT+Mp1Ym+CEj1SUwAxQ=SMv8BBh17=v4@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alex Hunsaker 2010-08-02 15:03:16 Re: Application user name attribute on connection pool
Previous Message Tom Lane 2010-08-02 14:31:46 Re: 8.4 backpatching