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: Fri, 12 May 2006 12:48:52 -0200
Message-ID: <20060512143716.M32697@techforce.com.br> (raw)
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 executes in less than 2
seconds and postgresql took almost half hour to complete at 100% cpu.
you could download the test database at the address below. It is a 128 kpbs
adsl connection.
74 MB
http://www.eicomm.no-ip.com/download/BackDNF_Cript.zip
Many thanks.
Andre Felipe Machado
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: <20060512143716.M32697@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