Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group