Content-Type: text/plain; charset=utf-8; format=flowed; delsp=yes
To: pgsql-performance@postgresql.org, "Tom Polak"
	<tom@rockfordarearealtors.org>
Subject: Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows
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>
Date: Thu, 09 Dec 2010 00:35:34 +0100
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
From: "Pierre C" <lists@peufeu.com>
Message-ID: <op.vne45kfjeorkce@apollo13>
In-Reply-To: <fd4bd31b523753145cf67ae6e6cb4aec@mail.gmail.com>
User-Agent: Opera Mail/10.62 (Linux)

> The hardware it
> is running on is fairly good, dual Xeon CPUs, 4 GB of RAM, Raid 5.

For a database you'd want to consider replacing the RAID1 with a RAID1 (or  
RAID10). RAID5 is slow for small random updates, which are common in  
databases. Since you probably have enough harddisks anyway, this won't  
cost you. Linux or freebsd would also be better choices for postgres  
rather than windows.

Also, as said, your issue looks very much like a problem in the way your  
application communicates with postgres : if it takes postgres 5 ms to  
process the query and your application gets the result 8 seconds later,  
there is a problem. Note that SQL Server probably takes just a few ms for  
such a simple query, too, so your not really benchmarking SQL server  
either.