pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Arnau <arnaulist@andromeiberica.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Where is my bottleneck?
Date: Tue, 24 Jan 2006 20:53:50 +0100
Message-ID: <43D685CE.1030206@andromeiberica.com> (raw)
In-Reply-To: <1138129693.25819.35.camel@state.g2switchworks.com>
References: <43D67477.8020204@andromeiberica.com>
	<1138129693.25819.35.camel@state.g2switchworks.com>

Scott Marlowe wrote:

> Well, this might get more traction on the perform list, just fyi.  Admin
> is more generally for questions about adding users, setting permissions
> and such.

   I know and I apologize for the cross-posting, I also sent the same 
message to the performance list.

> 
> That said, it looks like you're likely I/O bound.
> 
> Do you have Hyperthreading turned on?

   yes I have, when I do cat /proc/cpuinfo I get 4 CPUs

> 
> What do iostat and vmstat have to say?

here I post the result of iostat 10 -x

asme@SD22-SINER5:/$ iostat 10 -x
Linux 2.4.26-1-686-smp (SD22-SINER5)    01/24/06

avg-cpu:  %user   %nice    %sys %iowait   %idle
           16.03    0.00   94.98    0.00  144.54

Device:    rrqm/s wrqm/s   r/s   w/s  rsec/s  wsec/s    rkB/s    wkB/s 
avgrq-sz avgqu-sz   await  svctm  %util
scsi/host0/bus1/target0/lun0/disc
             89.37  14.15 48.15 95.82    1.30   25.54     0.65    12.77 
     0.79     0.00    0.05   0.00   0.00
scsi/host0/bus1/target0/lun0/part1
              0.00   0.00  0.00  0.00    0.00    0.00     0.00     0.00 
     4.26     0.00   48.69  48.63   0.00
scsi/host0/bus1/target0/lun0/part2
              0.01   0.25  0.02  0.22    0.22    3.77     0.11     1.89 
    17.12     0.00    6.29   1.80   0.04
scsi/host0/bus1/target0/lun0/part5
              0.02   0.02  0.01  0.00    0.21    0.20     0.10     0.10 
    33.85     0.00   58.89  38.02   0.05
scsi/host0/bus1/target0/lun0/part6
              0.05   0.35  0.10  0.47    1.18    6.55     0.59     3.27 
    13.58     0.00    2.70   1.64   0.09
scsi/host0/bus1/target0/lun0/part7
              0.06   0.60  0.01  0.03    0.53    5.10     0.27     2.55 
   137.26     0.00   38.02  22.68   0.09
scsi/host0/bus1/target0/lun0/part8
              0.14   0.57  0.01  0.03    1.18    4.79     0.59     2.40 
   155.70     0.00   12.07  14.63   0.06
scsi/host0/bus1/target0/lun0/part9
             89.09  12.35 48.00 95.07  107.78    5.13    53.89     2.56 
     0.09     0.00    0.04   0.02   0.05

avg-cpu:  %user   %nice    %sys %iowait   %idle
           27.35    0.00   16.25    0.00   56.40

Device:    rrqm/s wrqm/s   r/s   w/s  rsec/s  wsec/s    rkB/s    wkB/s 
avgrq-sz avgqu-sz   await  svctm  %util
scsi/host0/bus1/target0/lun0/disc
            420.60 2070.00 87.30 152.10 4060.00 17830.40  2030.00 
8915.20    91.44    14.06   57.70   4.16  99.60
scsi/host0/bus1/target0/lun0/part1
              0.00   0.00  0.00  0.00    0.00    0.00     0.00     0.00 
     0.00     0.00    0.00   0.00   0.00
scsi/host0/bus1/target0/lun0/part2
              0.00   0.70  0.00  1.40    0.00   16.80     0.00     8.40 
    12.00     0.07   52.14   5.00   0.70
scsi/host0/bus1/target0/lun0/part5
              0.00   0.00  0.00  0.00    0.00    0.00     0.00     0.00 
     0.00     0.00    0.00   0.00   0.00
scsi/host0/bus1/target0/lun0/part6
              0.00   0.40  0.00  0.40    0.00    6.40     0.00     3.20 
    16.00     0.02   40.00  40.00   1.60
scsi/host0/bus1/target0/lun0/part7
              0.00   0.00  0.00  0.00    0.00    0.00     0.00     0.00 
     0.00     0.00    0.00   0.00   0.00
scsi/host0/bus1/target0/lun0/part8
              0.00   0.00  0.00  0.00    0.00    0.00     0.00     0.00 
     0.00     0.00    0.00   0.00   0.00
scsi/host0/bus1/target0/lun0/part9
            420.60 2068.90 87.30 150.30 4060.00 17807.20  2030.00 
8903.60    92.03    13.97   57.77   4.19  99.60

avg-cpu:  %user   %nice    %sys %iowait   %idle
           31.38    0.00   15.55    0.00   53.08

Device:    rrqm/s wrqm/s   r/s   w/s  rsec/s  wsec/s    rkB/s    wkB/s 
avgrq-sz avgqu-sz   await  svctm  %util
scsi/host0/bus1/target0/lun0/disc
            388.80 2266.70 219.20 182.00 4876.80 19571.20  2438.40 
9785.60    60.94    21.54 1059879.18   2.49  99.80
scsi/host0/bus1/target0/lun0/part1
              0.00   0.00  0.00  0.00    0.00    0.00     0.00     0.00 
     0.00     0.00    0.00   0.00   0.00
scsi/host0/bus1/target0/lun0/part2
              0.00   0.30  0.00  0.40    0.00    5.60     0.00     2.80 
    14.00     0.01   17.50  17.50   0.70
scsi/host0/bus1/target0/lun0/part5
              0.00   0.00  0.00  0.00    0.00    0.00     0.00     0.00 
     0.00     0.00    0.00   0.00   0.00
scsi/host0/bus1/target0/lun0/part6
              0.00   0.20  0.00  0.40    0.00    4.80     0.00     2.40 
    12.00     0.01   22.50  22.50   0.90
scsi/host0/bus1/target0/lun0/part7
              0.00   0.00  0.00  0.00    0.00    0.00     0.00     0.00 
     0.00     0.00    0.00   0.00   0.00
scsi/host0/bus1/target0/lun0/part8
              0.00   0.00  0.00  0.00    0.00    0.00     0.00     0.00 
     0.00     0.00    0.00   0.00   0.00
scsi/host0/bus1/target0/lun0/part9
            388.80 2266.20 219.20 181.20 4876.80 19560.80  2438.40 
9780.40    61.03    21.52   54.32   2.49  99.80


> Does your RAID 5 have the option for batter backed cache?

   I don't know how to do that, I didn't configure this machine.

> Is your load mostly read, or a mix or read and write?

   On this machine there are about 200 DDBB running on it, the activity 
on them is a mix of read/write operations some depending on the tables 
of each DB. The size of the DB varies a lot, every day we do a pg_dump 
with a compressed format. The biggest one takes 746M, 5 are between 46M 
and 13M. 40 between 10M - 1M and the rest their dump takes less than 1M.

Cheers!
-- 
Arnau



view thread (11+ messages)  latest in thread

Message-ID: <43D685CE.1030206@andromeiberica.com>
Permalink:  ../43D685CE.1030206@andromeiberica.com/
Also on:    postgresql.org/message-id/43D685CE.1030206@andromeiberica.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: arnaulist@andromeiberica.com
  Subject: Re: Where is my bottleneck?
  In-Reply-To: <43D685CE.1030206@andromeiberica.com>
  References: <43D67477.8020204@andromeiberica.com> <1138129693.25819.35.camel@state.g2switchworks.com> <43D685CE.1030206@andromeiberica.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox