Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id E731864FC41 for ; Mon, 8 Dec 2008 12:18:02 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 67882-07 for ; Mon, 8 Dec 2008 12:17:57 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.178]) by mail.postgresql.org (Postfix) with ESMTP id 68B9D64FDBD for ; Mon, 8 Dec 2008 12:17:55 -0400 (AST) Received: by wa-out-1112.google.com with SMTP id j4so575896wah.19 for ; Mon, 08 Dec 2008 08:17:53 -0800 (PST) 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=40Q149wO8iOZp+8YFKM0ccbtvA8mi0jYMFQrCH0cRrY=; b=vjdrydFuB0s+DFQ6LMsEhWGkmskhSmK6R843AlyHtaL037Wvx0H6mIOgyhhCfuuQU7 sop4yjN35ZSdRTEHvXTYxhuX5RZLhi4y7B1HJ9IYo7/0NI3+iqeIazIYg6+7p4/fUeEi w6WtQdmojbNPSjOkP8EqmBCd/pXGBgH/L0lS0= 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=w3tyFzDtygzIj8pdc86HXG3Es63gEmcOOGsBETSWaQI04ce5CFjF07qMUvPSseM4As DUY8b0FLo8inlJtiuj8cnoD5azfnJnogJvrB8YPdyeyS5jd6lI3oocOTqqARzjmHMVPH fjXNCnj8TzFN+7UHglzG7/k2KKV51AAmDb354= Received: by 10.115.23.19 with SMTP id a19mr2517239waj.63.1228753073855; Mon, 08 Dec 2008 08:17:53 -0800 (PST) Received: by 10.114.133.4 with HTTP; Mon, 8 Dec 2008 08:17:53 -0800 (PST) Message-ID: Date: Mon, 8 Dec 2008 09:17:53 -0700 From: "Scott Marlowe" To: "Rafael Domiciano" Subject: Re: Vacuum Problems Cc: "Matthew T. O'Connor" , "Rafael Martinez" , "pgsql-admin@postgresql.org" In-Reply-To: <3a0028490812080811r1c8a4756i1a1a514911741def@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <3a0028490811260543x74d02719w775a457999cfc74@mail.gmail.com> <492D5C87.5090505@usit.uio.no> <3a0028490811260700w6e8d9d86o24effbe0bea2bddb@mail.gmail.com> <3a0028490811260921l5d6aac06v54dca32aae672b97@mail.gmail.com> <492DA95D.3010303@zeut.net> <3a0028490812080504x22618c6fxd7df8febaadb1632@mail.gmail.com> <3a0028490812080811r1c8a4756i1a1a514911741def@mail.gmail.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: 200812/51 X-Sequence-Number: 30884 On Mon, Dec 8, 2008 at 9:11 AM, Rafael Domiciano wrote: > How I do to see my I/O subsystem? vmstat? If so, follow: No, I mean, how many drives do you have, what kind of RAID controller, if any, how they're configured, and so on. :) Sorry wasn't really clear there was I? The vmstat numbers are horrible by the way, assuming they're in 1k blocks, you're reading and writing at < 1 Meg a second. It almost looks like a degraded RAID-5 array.