Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 791D764FD1B for ; Tue, 16 Sep 2008 14:30:23 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 89848-04 for ; Tue, 16 Sep 2008 14:30:20 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from wf-out-1314.google.com (wf-out-1314.google.com [209.85.200.171]) by postgresql.org (Postfix) with ESMTP id B3D7A64FD12 for ; Tue, 16 Sep 2008 14:30:20 -0300 (ADT) Received: by wf-out-1314.google.com with SMTP id 25so2617020wfc.28 for ; Tue, 16 Sep 2008 10:30:19 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:cc:in-reply-to:mime-version:content-type :content-transfer-encoding:content-disposition:references; bh=89/jki2r9nmnDYezuSE5LSd97jM++jGsfQXY2JyaaIA=; b=I8NwWMM7FOvwWjIq1DKTcxqZc4cQrPly4sIBXrr9aLUcc/PmAPmdjdqffSiUSZaI5z V6iovRKFi5Ev0qjvs7FzZyNabyBfvrk7Pc6gIkRzt6w5eUIMuhLYtqjdOZsvkbH0uZPN Gf9SFy2GKx/eAFd+nTwQbvkBBaWUhJ0fEp0PU= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version :content-type:content-transfer-encoding:content-disposition :references; b=mXfxOQEVStcnGPIWblQ8HuFWlIlFZtcu5/mUyOZ3j0zGFtoW8WS5b3Nz9wP9ztX78A o6VNggm+jKs91nNDaxu6nkrn+lshhei5Nc7OehuB0+Hh5YHtj7dfspcsLIrKIGU2W4UR 6tRcK1SKbn4vKIbI34e0YammdXx1Yn5NLtgVk= Received: by 10.140.157.5 with SMTP id f5mr5859097rve.267.1221586219292; Tue, 16 Sep 2008 10:30:19 -0700 (PDT) Received: by 10.141.74.11 with HTTP; Tue, 16 Sep 2008 10:30:19 -0700 (PDT) Message-ID: Date: Tue, 16 Sep 2008 11:30:19 -0600 From: "Scott Marlowe" To: "Guido Barosio" Subject: Re: Heavy postgres process Cc: Vivek_Sharan , "pgsql-admin@postgresql.org" In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <5465CC59A600E2408FFBF84350B938345031E95B93@AUSMELMBX01.ad.infosys.com> <5465CC59A600E2408FFBF84350B9383450F4933AB6@AUSMELMBX01.ad.infosys.com> <5465CC59A600E2408FFBF84350B9383450F4933C33@AUSMELMBX01.ad.infosys.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200809/163 X-Sequence-Number: 30256 On Tue, Sep 16, 2008 at 8:37 AM, Guido Barosio wrote: > On Tue, Sep 16, 2008 at 1:41 AM, Vivek_Sharan wrote: >> Thanks for the information so far OK, I'm not BSD expert (Tom Lane might help out here) but I'm guessing that what we see in the following lines of top: >> 87340 postgres 2 0 7200K 1224K select 0 1:41 0.00% 0.00% postgres >> 90961 postgres 2 0 83580K 76008K sbwait 0 0:30 0.00% 0.00% postgres >> 90920 postgres 2 0 83636K 76068K sbwait 0 0:29 0.00% 0.00% postgres Is that the number on the left, like 83636K is the total memory used, and the number to the right 76068K is how much is shared buffers etc... which would mean that each of those processes above are using about 7 megs a piece, and the rest is repeated.