Hello,
continuing the saga,
http://archives.postgresql.org/pgsql-performance/2006-04/msg00558.php ,
my coleague created a test database with fake data (see below).
The above archived message contains the the timings of firebird and postgresql.
The weird problem are the 2 queries that firebird exe
Hello,
Many thanks for your suggestions.
I will try them.
The last two queries almost did not use disk, but used 100% cpu.
The differences of performance are big.
Firebird has something similiar to EXPLAIN. Please look below.
Is there something really wrong with the postgresql configuration (at my
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
Hello,
Many thanks for your suggestions.
I am trying to optimize server configs, as (presumed) my friend already
optimized his queries and firebird windows is executing them fast.
You could see at the new attached file the results of the queries rewrite.
Unfortunately, the first query simply return
Hello,
Attached is a file containing the problematic queries cited yesterday, with
"explain", "\di" and "show all" outputs.
The first one finished in almost 4 hours. Firebird for windows finished in
1m30s.
The second one CRASHED after some hours, without finishing. The error message
is at the file
Hello,
Attached is the text file containing the last rounds of configurations.
This time, used "show all" just before issuing each relevant "explain analyze"
to ensure available information.
Note that the last runs are being executed concurrently with other problematic
query that is consuming 100%
Hello,
A friend asked for help to accelerate some postgresql queries on postgresql
8.1.2 for windows.
He is comparing with firebird.
Firebird was being up to 90 times faster at some queries.
Attached is a gziped text file containing some steps I tried on a simple
example query.
Could get improvemen
