Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 992C56353E3 for ; Fri, 25 Jun 2010 12:15:08 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 75220-04-4 for ; Fri, 25 Jun 2010 15:15:01 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-gy0-f174.google.com (mail-gy0-f174.google.com [209.85.160.174]) by mail.postgresql.org (Postfix) with ESMTP id 5B68563419A for ; Fri, 25 Jun 2010 12:14:42 -0300 (ADT) Received: by gyd12 with SMTP id 12so129881gyd.19 for ; Fri, 25 Jun 2010 08:14:41 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:received:in-reply-to :references:date:message-id:subject:from:to:cc:content-type; bh=LWiC0IOEtSSpzVbuK5W8Z4R4uw6aaLoEn93P5IFi4Ss=; b=FcWhk3X5Ru6zzr5T6TWUtrQ4J0QqCkzEyOdabRwXEbNyIqYS14iglMn/lC/8tm4uIm Y1ridAW/S0KtWfc/K0/EsnNBakrtQPh+OQeaSpWaMcBeGmlggFF7zprFZW6nd77WSQZ0 0umhABaDr3fj+4GxZZroUJ07clOp9m6z4o8/E= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; b=FhJ0on+snWTwY2vZPkprhVhF/8PeLi6r/bdRcuXDdtqgA5WmZOjreiqjByoa+gmGpY Gv8xG+bz6sGXGg5kHqBLicEnlgrJn+PsKIPhpIR1yZQBurbJzxHRw2uVmzyy6ZJVLvND RTgROI+gJa3ggBaHcXHXTaAfyfs5AiuG4KAHo= MIME-Version: 1.0 Received: by 10.229.193.16 with SMTP id ds16mr551117qcb.148.1277478881424; Fri, 25 Jun 2010 08:14:41 -0700 (PDT) Received: by 10.229.233.80 with HTTP; Fri, 25 Jun 2010 08:14:41 -0700 (PDT) In-Reply-To: <4C2477A20200002500032B03@gw.wicourts.gov> References: <4C2492F9.2020706@gmail.com> <4C2477A20200002500032B03@gw.wicourts.gov> Date: Fri, 25 Jun 2010 20:44:41 +0530 Message-ID: Subject: Re: sudden spurt in swap utilization (was:cpu bound postgresql setup.) From: Rajesh Kumar Mallah To: Kevin Grittner Cc: Yeb Havinga , pgsql-performance@postgresql.org Content-Type: text/plain; charset=ISO-8859-1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.8 tagged_above=-10 required=5 tests=BAYES_50=0.8 X-Spam-Level: X-Archive-Number: 201006/466 X-Sequence-Number: 39322 I changed shared_buffers from 10G to 4G , swap usage has almost become nil. # free total used free shared buffers cached Mem: 32871276 24575824 8295452 0 11064 22167324 -/+ buffers/cache: 2397436 30473840 Swap: 4192912 352 4192560 I also observed that there was a huge IO wait and load spike initially which gradually reduced to normal levels. Now things seems to be fine. but real test shall be during business hours. vmstat output: http://pastebin.com/ygu8gUhS the iowait now is very respectable < 10% and CPU is idling most of the time. # vmstat 10 procs -----------memory---------- ---swap-- -----io---- --system-- -----cpu------ r b swpd free buff cache si so bi bo in cs us sy id wa st 2 1 352 8482444 11336 22299100 1 0 450 208 0 0 50 6 39 5 0 4 0 352 8393840 11352 22304484 0 0 480 163 9260 12717 32 4 62 3 0 5 1 352 8474788 11360 22308980 0 0 304 445 8295 12358 28 4 67 2 0 3 0 352 8370672 11376 22316676 0 0 648 158 8760 13214 38 4 55 3 0 11 0 352 8193824 11392 22323572 0 0 621 577 8800 13163 37 4 56 3 0 2 0 352 8229012 11408 22326664 0 0 169 405 9588 13696 34 4 61 1 0 6 1 352 8319176 11424 22333144 0 0 559 170 8830 12929 32 4 61 3 0 I shall also try pgtune in a while.