Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 0FA2CB5DF05 for ; Tue, 6 Sep 2011 16:08:18 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 18002-01-2 for ; Tue, 6 Sep 2011 19:08:11 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from zeus.simkin.ca (zeus.simkin.ca [72.51.27.124]) by mail.postgresql.org (Postfix) with ESMTP id CDA09B5DF34 for ; Tue, 6 Sep 2011 16:08:01 -0300 (ADT) X-Postmaster: whitelisted richard@aggress.net Received: from pc-1072.reinvent.com (office.reinvent.com [72.51.27.254]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by zeus.simkin.ca (Postfix) with ESMTPSA id ED6052702EF; Tue, 6 Sep 2011 12:07:59 -0700 (PDT) From: Alan Hodgson Organization: Simkin Network Consulting To: pgsql-performance@postgresql.org Subject: Re: Rather large LA Date: Tue, 6 Sep 2011 12:07:56 -0700 User-Agent: KMail/1.13.6 (Linux/2.6.38-11-generic; KDE/4.6.2; x86_64; ; ) References: <201109051305.07010@hal.medialogik.com> <9BFA2771-CA9B-4EEF-B671-78FF67F749C6@aggress.net> In-Reply-To: <9BFA2771-CA9B-4EEF-B671-78FF67F749C6@aggress.net> Cc: Richard Shaw MIME-Version: 1.0 Content-Type: Text/Plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Message-Id: <201109061207.56559.ahodgson@simkin.ca> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.505 tagged_above=-10 required=5 tests=BAYES_40=-0.001, RP_MATCHES_RCVD=-0.504 X-Spam-Level: X-Archive-Number: 201109/65 X-Sequence-Number: 44841 On September 5, 2011 03:36:09 PM you wrote: > After Restart > > procs -----------memory---------- ---swap-- -----io---- --system-- > -----cpu------ r b swpd free buff cache si so bi bo in > cs us sy id wa st 2 34 2332 5819012 75632 25855368 0 0 89 > 42 0 0 7 5 85 3 0 4 39 2332 5813344 75628 25833588 0 0 > 5104 324 5480 27047 3 1 84 11 0 2 47 2332 5815212 75336 25812064 > 0 0 4356 1664 5627 28695 3 1 84 12 0 2 40 2332 5852452 75340 > 25817496 0 0 5632 828 5817 28832 3 1 84 11 0 1 45 2332 > 5835704 75348 25817072 0 0 4960 1004 5111 25782 2 1 88 9 0 2 > 42 2332 5840320 75356 25811632 0 0 3884 492 5405 27858 3 1 > 88 8 0 0 47 2332 5826648 75348 25805296 0 0 4432 1268 5888 > 29556 3 1 83 13 0 > > avg-cpu: %user %nice %system %iowait %steal %idle > 3.26 0.00 1.69 25.21 0.00 69.84 > > Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz > avgqu-sz await svctm %util sda 0.50 45.00 520.00 > 2.50 8316.00 380.00 16.64 71.70 118.28 1.92 100.10 sda1 > 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 > 0.00 0.00 0.00 sda2 0.50 45.00 520.00 2.50 8316.00 > 380.00 16.64 71.70 118.28 1.92 100.10 sda3 0.00 > 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 > sdb 0.00 196.50 0.00 10.50 0.00 1656.00 157.71 > 0.01 0.67 0.52 0.55 sdb1 0.00 196.50 0.00 10.50 > 0.00 1656.00 157.71 0.01 0.67 0.52 0.55 > > avg-cpu: %user %nice %system %iowait %steal %idle > 3.97 0.00 1.71 20.88 0.00 73.44 Yeah 20% I/O wait I imagine feels pretty slow. 8 cores?