pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Pierre C <lists@peufeu.com>
To: pgsql-performance@postgresql.org, "Tom Polak" <tom@rockfordarearealtors.org>
Subject: Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows
Date: Thu, 09 Dec 2010 00:35:34 +0100
Message-ID: <op.vne45kfjeorkce@apollo13> (raw)
In-Reply-To: <fd4bd31b523753145cf67ae6e6cb4aec@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>

> 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.



view thread (31+ messages)  latest in thread

Message-ID: <op.vne45kfjeorkce@apollo13>
Permalink:  ../op.vne45kfjeorkce@apollo13/
Also on:    postgresql.org/message-id/op.vne45kfjeorkce@apollo13

 · 

reply
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: lists@peufeu.com, tom@rockfordarearealtors.org
  Subject: Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows
  In-Reply-To: <op.vne45kfjeorkce@apollo13>

* 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