Subject: Firebird 1.5.3 X Postgresql 8.1.3 (linux and windows)
From: =?ISO-8859-1?Q?Andr=E9?= Felipe Machado <andremachado@techforce.com.br>
To: pgsql-performance@postgresql.org
Cc: "Jim C. Nasby" <jnasby@pervasive.com>
In-Reply-To: <20060512191415.GT6201@pervasive.com>
References: <20060512143716.M32697@techforce.com.br>
	<20060512191415.GT6201@pervasive.com>
Content-Type: text/plain; charset=ISO-8859-1
Date: Sat, 13 May 2006 06:58:02 -0300
Message-Id: <1147514282.3896.12.camel@localhost.localdomain>
Mime-Version: 1.0
Content-Transfer-Encoding: 8bit

Hello, Jim
I did not want to clutter mailboxes of those who are not interested at
this weird problem.
So, i pointed to the archived message that contains 2 tar.gz files
(around 50 KB) with the two sets of queries (firebird and postgresql
respectively), its results, explain analyze, pg configurations, firebird
plan outputs, etc.
Please, open the cited link and scroll to the end of message. You will
find the 2 tar.gz files.
http://archives.postgresql.org/pgsql-performance/2006-04/msg00558.php
If you have some difficulty, I could send a private email containing the
2 files in order to not send the big email to the all list again.
Many thanks.
Andre Felipe Machado


Em Sex, 2006-05-12 às 14:14 -0500, Jim C. Nasby escreveu:
> On Fri, May 12, 2006 at 12:48:52PM -0200, andremachado wrote:
> > 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.
> 
> How about posting EXPLAIN ANALYZE for those two queries, as well as the
> queries themselves?