X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id E4369D1DA69 for ; Fri, 13 Feb 2004 22:00:16 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 61629-05 for ; Fri, 13 Feb 2004 18:00:19 -0400 (AST) Received: from bayswater1.ymogen.net (host-154-240-27-217.pobox.net.uk [217.27.240.154]) by svr1.postgresql.org (Postfix) with ESMTP id 8E924D1D5B0 for ; Fri, 13 Feb 2004 18:00:11 -0400 (AST) Received: by bayswater1.ymogen.net (Postfix, from userid 99) id 9AA069ACAF; Fri, 13 Feb 2004 22:00:14 +0000 (GMT) Received: from 82.68.132.233 (SquirrelMail authenticated user matt@ymogen.net) by webmail.ymogen.com with HTTP; Fri, 13 Feb 2004 22:00:14 -0000 (GMT) Message-ID: <1980.82.68.132.233.1076709614.squirrel@webmail.ymogen.com> In-Reply-To: <268071B6-5E67-11D8-AB22-0030658FB514@comvision.com> References: <70CC4F08-5D89-11D8-AB22-0030658FB514@comvision.com> <200402121226.33823.josh@agliodbs.com> <268071B6-5E67-11D8-AB22-0030658FB514@comvision.com> Date: Fri, 13 Feb 2004 22:00:14 -0000 (GMT) Subject: Re: Disappointing performance in db migrated from MS SQL From: matt@ymogen.net To: "Leon Out" Cc: pgsql-performance@postgresql.org User-Agent: SquirrelMail/1.4.2-0.1.7.x MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Priority: 3 Importance: Normal X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/160 X-Sequence-Number: 5684 > Josh, the disks in the new system should be substantially faster than > the old. Both are Ultra160 SCSI RAID 5 arrays, but the new system has > 15k RPM disks, as opposed to the 10k RPM disks in the old system. Spindle speed does not correlate with 'throughput' in any easy way. What controllers are you using for these disks?