From: andremachado <andremachado@techforce.com.br>
To: pgsql-performance@postgresql.org
Subject: Firebird 1.5.3 X Postgresql 8.1.3 (linux and windows)
Date: Tue, 25 Apr 2006 14:38:16 -0200
Message-ID: <20060425160609.M20649@techforce.com.br> (raw)
Hello,
The performance comparison saga of the last month continues (see list archive).
After some time experimenting on windows, the conclusion is clear:
windows is likely crap for databases other than MS-SQL.
I guess that MS-SQL uses lot of undocumented api calls, may run in kernel
mode, ring 0 and a lot of dirty tricks to get some reasonable performance.
Then, I asked my coleague to send a new FB dump and a Pg dump to try at my
desktop machine.
This time, the database is somewhat bigger. Around 20 million records.
The timings are attached. Tried to follow the same query sequence on both files.
Both databases are much more faster on linux than on windows, and the desktop
machine is not dedicated and tuned. (no scsi, no raid, many services enabled,
ext3 fs, etc).
At many of the queries, postgresql is faster, sometimes way MUCH faster.
But Firebird have very good defaults out of the box and a few of the queries
are really a pain in Postgresql.
Please, see the abismal timing differences at the last 2 queries, for example.
They used 100% cpu, almost no disk activity, no twait cpu, for loooong time to
complete.
Maybe these queries bring into the light some instructions weaknesses, or bad
tuning.
Do you have some suggestions?
Regards.
Andre Felipe Machado
http://www.techforce.com.br
linux blog
Attachments:
queries_timing_firebird.txt.tar.gz (application/x-gzip, 1.7K) download
queries_timing_postgresql.txt.tar.gz (application/x-gzip, 9.8K) download
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: andremachado@techforce.com.br
Subject: Re: Firebird 1.5.3 X Postgresql 8.1.3 (linux and windows)
In-Reply-To: <20060425160609.M20649@techforce.com.br>
* 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