Re: Disappointing performance in db migrated from MS SQL

From: matt(at)ymogen(dot)net
To: "Leon Out" <leon-lists(at)comvision(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Disappointing performance in db migrated from MS SQL
Date: 2004-02-13 22:00:14
Message-ID: 1980.82.68.132.233.1076709614.squirrel@webmail.ymogen.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> 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?

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Vivek Khera 2004-02-13 22:01:42 Re: Disappointing performance in db migrated from MS SQL Server
Previous Message Leon Out 2004-02-13 21:03:24 Lengthy pg_restore and high iowait?