X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 04A0F9F9F7E for ; Wed, 13 Sep 2006 17:35:20 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 99674-05-2 for ; Wed, 13 Sep 2006 20:35:12 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.mi8.com (d01gw02.mi8.com [63.240.6.46]) by postgresql.org (Postfix) with ESMTP id 1017F9FB1D7 for ; Wed, 13 Sep 2006 17:35:10 -0300 (ADT) Received: from 172.16.1.112 by mail.mi8.com with ESMTP (- Welcome to Mi8 Corporation www.Mi8.com (D2)); Wed, 13 Sep 2006 16:34:51 -0400 X-Server-Uuid: 7829E76E-BB9E-4995-8473-3C0929DF7DD1 Received: from MI8NYCMAIL06.Mi8.com ([172.16.1.160]) by D01SMTP02.Mi8.com with Microsoft SMTPSVC(6.0.3790.1830); Wed, 13 Sep 2006 16:33:50 -0400 Received: from 63.80.24.130 ([63.80.24.130]) by MI8NYCMAIL06.Mi8.com ( [172.16.1.219]) via Exchange Front-End Server mi8owa.mi8.com ( [172.16.1.118]) with Microsoft Exchange Server HTTP-DAV ; Wed, 13 Sep 2006 20:33:50 +0000 User-Agent: Microsoft-Entourage/11.2.5.060620 Date: Wed, 13 Sep 2006 13:33:48 -0700 Subject: Re: Poor performance on seq scan From: "Luke Lonergan" To: "Dave Cramer" , "Laszlo Nagy" cc: pgsql-performance@postgresql.org Message-ID: Thread-Topic: [PERFORM] Poor performance on seq scan Thread-Index: AcbXc+pfKPa90kNnEduoJAAWy4o9DA== In-Reply-To: <1BD8A62B-DE69-4EFA-9EB6-D11B7CBDDA9E@fastcrypt.com> MIME-Version: 1.0 X-OriginalArrivalTime: 13 Sep 2006 20:33:50.0903 (UTC) FILETIME=[EC1AD470:01C6D773] X-WSS-ID: 6916B4E11401373495-04-01 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.5 tagged_above=0 required=5 tests=RCVD_NUMERIC_HELO X-Spam-Level: * X-Archive-Number: 200609/132 X-Sequence-Number: 20818 Lazlo, >> Thank you for your suggestions. Looks like I need to buy SCSI disks. > > Well before you go do that try the areca SATA raid card Yes, by all means spend $200 and buy the Areca or 3Ware RAID card - it's a simple switch out of the cables and you should be golden. Again - you should only expect an increase in performance from 4-6 times from what you are getting now unless you increase the number of disks. - Luke