From: | Russ Brown <pickscrape(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Benchmark-Comparison PostGreSQL vs. SQL Server |
Date: | 2006-03-07 14:59:20 |
Message-ID: | 20060307085920.60938c3c@mixolydian.my-domain.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Thu, 25 Nov 2004 11:36:33 +0100
"Robert Soeding" <robert(dot)soeding(at)lisocon(dot)de> wrote:
> Hi, this is my first question here, and also, it's somewhat delicate.
> So please be patient.
> My question is, CAN PostGreSQL perform in the SQL Server area when it
> comes to speed? In other words, are there explanations for the
> results I found (see below)?
> Thanks,
> Robert
>
> -----
> Background:
> 1. I read people were using PostGreSQL with TeraBytes of data
> sometimes, or thousands of users. These are things that could easily
> break SQL Server. - So I thought PostGreSQL might be similar fast to
> SQL Server. 2. I did some tests: Windows XP SP2
> Several GIGs free harddisk, ~400 MB free RAM
> Java 1.5 / JDBC
> PostGreSQL 8.0 beta (through Windows Installer), default
> configuration, default driver SQL Server 2000 SP3a, default
> configuration,
Here's your problem right here. You're never going to get a fair
comparison unless you tune the crap out of *both* contenders.
PostgreSQL's default configuration is extremely conservative to allow
it to be run on very limited resources.
> JDTS driver Tablespaces of both databases on the same
> partition Write-Test: Creating tables (slightly modified TCP-W
> benchmark) Read-Test: Simple SELECT statements on all tables,
> returning the first 1000 rows (cursor variants: read-only and
> non-locking, resp. updatable and locking) Results:
> Writing: SQL Server 25 times faster.
> Reading: SQL Server 100 times faster.
--
Russ
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2006-03-07 15:04:38 | Re: Question about index usage |
Previous Message | Tom Lane | 2006-03-07 14:57:30 | Re: pg_dump error - filesystem full |