On Fri, Dec 17, 2010 at 10:08 AM, Tom Polak
<t...@rockfordarearealtors.org> wrote:
> What kind of performance can I expect out of Postgres compare to MSSQL?

You should take any generalizations with a grain of salt. I suggest
that you do a POC.

> Let's assume that Postgres is running on Cent OS x64 and MSSQL is running
> on Windows 2008 x64, both are on identical hardware running RAID 5 (for
> data redundancy/security), SAS drives 15k RPM, dual XEON Quad core CPUs,
> 24 GB of RAM.

RAID-5 = suckage for databases.

Things to think about:
How big is your data set and how big is your working set?
Do you have a raid card? Is it properly configured?


-- 
Rob Wultsch
wult...@gmail.com

-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

Reply via email to