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