Postgres Pro
Downloads
Home   >   mailing lists

Re: Disappointing performance in db migrated from MS SQL - Mailing list pgsql-performance

From matt@ymogen.net
Subject Re: Disappointing performance in db migrated from MS SQL
Date
Msg-id 1980.82.68.132.233.1076709614.squirrel@webmail.ymogen.com
Whole thread Raw
In response to Re: Disappointing performance in db migrated from MS SQL Server  (Leon Out <leon-lists@comvision.com>)
Responses Re: Disappointing performance in db migrated from MS SQL
List pgsql-performance
Tree view 
> 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?

pgsql-performance by date:

Previous
From: Leon Out
Date:
Subject: Lengthy pg_restore and high iowait?
Next
From: Vivek Khera
Date:
Subject: Re: Disappointing performance in db migrated from MS SQL Server