Re: Fw: Fw: bad performance on irix - Mailing list pgsql-hackers

I've done some meditions with timex, it uses sar(System activity register)
to take workloads, it's not very relliable, but it allow us to see how it is
been doing,  it has been taken during an execution of a like tpc-h
benchmark, it performs inserts, deletes(about 5% of the time of the
execution) and a set of 8 continous streams of 22 read only queries, notice
that it only gives idle time (not the cause of idle), notice semafores/sec
is up to 2700!!!!!!!
Regards
12:27:08  %usr  %sys %intr  %wio %idle %sbrk  %wfs %wswp %wphy %wgsw %wfif
12:55:39    32     3         0         9    56         0       100     0
0     0     0                                    9% waiting for I/O which is
100% file system

12:27:08     device %busy  avque  r+w/s  blks/s    w/s wblks/s  avwait
avserv
12:55:39     dks0d5     0    0.0    0.0       0    0.0       0     0.0
0.0                dks1d1     1    3.1    0.7      19    0.7      16    27.8
15.0                dks1d2     0    1.0    0.0       0    0.0       0     0.0
13.3                dks1d3     0    0.0    0.0       0    0.0       0     0.0
0.0                dks1d4    23   15.3    9.1    1705    7.8    1553   519.7
24.8

12:27:08 bread/s lread/s %rcach bwrit/s lwrit/s wcncl/s %wcach pread/s
pwrit/s
12:55:39     158    2372     93    1549    9072       1     83       0
0                    93% of read cache hits and 83% of write chache hits

12:27:08     scall/s sread/s swrit/s  fork/s  exec/s rchar/s wchar/s
12:55:39    4618     181     126    0.18    0.06  648854  580354
syscalls averages

12:27:08   msg/s  sema/s
12:55:39    0.00 2704.28

12:27:08  vflt/s         dfill/s cache/s pgswp/s pgfil/s  pflt/s  cpyw/s
steal/s rclm/s        notice that there aren't page swaps, so idle is not
waiting for paging
12:55:39  862.58   58.31  804.24    0.00    0.04    5.70    3.11   60.90
0.00

12:27:08    CPU  %usr  %sys %intr %wio %idle %sbrk  %wfs %wswp %wphy %wgsw
%wfif
12:55:39     0        25     3     0     8    63     0   100     0     0
0     0                                                  per  CPU usage                 1        25     3     0     9
62     0   100     0
 
0     0     0                2        24     3     0     9    64     0   100     0     0
0     0                3        30     3     0     8    59     0   100     0     0
0     0                4        30     3     0     8    59     0   100     0     0
0     0                5        39     3     0     8    50     0   100     0     0
0     0                6        54     3     0     8    34     0   100     0     0
0     0                7        33     3     0     8    55     0   100     0     0
0     0