Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id F335462DBEA for ; Tue, 6 Jan 2009 14:45:52 -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 22499-01 for ; Tue, 6 Jan 2009 14:45:47 -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.182]) by mail.postgresql.org (Postfix) with ESMTP id D815F62DBE4 for ; Tue, 6 Jan 2009 14:45:46 -0400 (AST) Received: by wa-out-1112.google.com with SMTP id j4so4420188wah.19 for ; Tue, 06 Jan 2009 10:45:45 -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=TX5HvKXZzJ0G6RHs1N9OPloFnTR8REIgI1B9JrOmQ1g=; b=JUExwKrMhSIXUfDrAtWqPxgCmItDI3yYo/RR42YiU474mPS2Ermz6wGV7RGLQ7J+w8 zyioDF2baxu2L9rTx0e54hNbwDoH4wDJ/GmkCj36AgvJJ7+ZVhpM4P03es+BC/6smo3t bhNKvLK8tmKcHzr1pXp+AT9Jrw9pphP5ypD/o= 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=BrTmeH86+OyonRipG4isCY1VyIEi8Imecgjgm7d7PLYsGvK4NOnCFQc5sTnm7XcAzK wfNWsWU/RfmwDAbq4f27S/bb8ISoF+2fAb6kMwBcbxmRn5NEv0qp0tcwZM2i/T1/HrO/ JJgVVvw35dVZoQ2OKOotBm38PKHtg85e/OwbU= Received: by 10.115.92.2 with SMTP id u2mr14672553wal.137.1231267545183; Tue, 06 Jan 2009 10:45:45 -0800 (PST) Received: by 10.115.108.3 with HTTP; Tue, 6 Jan 2009 10:45:45 -0800 (PST) Message-ID: Date: Tue, 6 Jan 2009 11:45:45 -0700 From: "Scott Marlowe" To: "Stefano Nichele" Subject: Re: understanding postgres issues/bottlenecks Cc: pgsql-performance@postgresql.org In-Reply-To: <49638BE9.2030701@gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <49638BE9.2030701@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: 200901/14 X-Sequence-Number: 32293 I concur with Merlin you're I/O bound. Adding to his post, what RAID controller are you running, does it have cache, does the cache have battery backup, is the cache set to write back or write through? Also, what do you get for this (need contrib module pgbench installed) pgbench -i -s 100 pgbench -c 50 -n 10000 ? Specifically transactions per second?