X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 981AFD1B4E1 for ; Wed, 1 Oct 2003 13:26:19 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 33796-10 for ; Wed, 1 Oct 2003 10:25:37 -0300 (ADT) Received: from mail.libertyrms.com (unknown [209.167.124.227]) by svr1.postgresql.org (Postfix) with ESMTP id 3A441D1B540 for ; Wed, 1 Oct 2003 10:25:33 -0300 (ADT) Received: from [10.1.2.130] (helo=dba2) by mail.libertyrms.com with esmtp (Exim 3.22 #3 (Debian)) id 1A4gz3-0004sz-00 for ; Wed, 01 Oct 2003 09:25:37 -0400 Received: by dba2 (Postfix, from userid 1019) id F3674CB29; Wed, 1 Oct 2003 09:25:36 -0400 (EDT) Date: Wed, 1 Oct 2003 09:25:36 -0400 From: Andrew Sullivan To: pgsql-performance@postgresql.org Subject: Re: inferior SCSI performance Message-ID: <20031001132536.GA30269@libertyrms.info> Mail-Followup-To: Andrew Sullivan , pgsql-performance@postgresql.org References: <20031001103338.GA29293@libertyrms.info> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.4i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/16 X-Sequence-Number: 3764 On Wed, Oct 01, 2003 at 07:14:32AM -0600, scott.marlowe wrote: > FYI, on a Dual PIV2800 with 2 gig ram and a single UDMA 80 gig hard drive, > I from 420 tps to 22 tps when I disable write caching. WOW. A factor of > about 20 times slower. (pgbench -c 4 -t 100) That's completely consistent with tests Chris Browne has done here on cache-enabled and cache-disabled boxes that we have. It's a _really_ big difference. The combination of battery-backed write cache on your controller plus a real good UPS is quite possibly the number one thing you can do to improve performance. For what it's worth, I can't see how this is something special about Postgres: even raw-filesystem type systems have to make sure the disk actually has the data, and a write cache is bound to be a big help for that. A -- ---- Andrew Sullivan 204-4141 Yonge Street Afilias Canada Toronto, Ontario Canada M2P 2A8 +1 416 646 3304 x110