From: Craig James <craig_james@emolecules.com>
To: pgsql-performance@postgresql.org
Subject: Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows
Date: Fri, 17 Dec 2010 09:32:32 -0800
Message-ID: <4D0B9EB0.1070708@emolecules.com> (raw)
In-Reply-To: <70e424e558d87f649f149bf2948d73cb@mail.gmail.com>
References: <378e24d1e3af88a49fbbb7c4d26f441a@mail.gmail.com>
<4CFE7964.80206@squeakycode.net>
<AANLkTi=HiO8ErFwzqBvgjXXHRUMKeUWqCpL-p9Y+oL_-@mail.gmail.com>
<4CFE8E59.2010505@squeakycode.net>
<AANLkTin4K86j2-GOUfmdXQ8UKv_j9V8ZRiRBEbbXj+jc@mail.gmail.com>
<20101207201028.GE4028@aart.is.rice.edu>
<4CFE97B4.8090708@squeakycode.net>
<fd4bd31b523753145cf67ae6e6cb4aec@mail.gmail.com>
<op.vne45kfjeorkce@apollo13>
<70e424e558d87f649f149bf2948d73cb@mail.gmail.com>
On 12/17/10 9:08 AM, Tom Polak wrote:
> So, I am back on this topic again.
> I have a related question, but this might be the correct thread (and
> please let me know that). The boss is pressing the issue because of the
> cost of MSSQL.
You need to analyze the total cost of the system. For the price of MSSQL and Windows, you can probably buy a couple more really nice servers, or one Really Big Server that would walk all over a Windows/MSSQL system of the same total cost (hardware+software).
But that said, if Postgres is properly tuned and your application tuned to make good use of Postgres' features, it will compare well with any modern database.
> What kind of performance can I expect out of Postgres compare to MSSQL?
> 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.
RAID5 is a Really Bad Idea for any database. It is S...L...O...W. It does NOT give better redundancy and security; RAID 10 with a battery-backed RAID controller card is massively better for performance and just as good for redundancy and security.
Craig
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: craig_james@emolecules.com
Subject: Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows
In-Reply-To: <4D0B9EB0.1070708@emolecules.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox