From: André Felipe Machado <andremachado@techforce.com.br>
To: pgsql-performance@postgresql.org
Cc: Jim C. Nasby <jnasby@pervasive.com>
Subject: Firebird 1.5.3 X Postgresql 8.1.3 (linux and windows)
Date: Sat, 13 May 2006 06:58:02 -0300
Message-ID: <1147514282.3896.12.camel@localhost.localdomain> (raw)
In-Reply-To: <20060512191415.GT6201@pervasive.com>
References: <20060512143716.M32697@techforce.com.br>
<20060512191415.GT6201@pervasive.com>
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?
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, jnasby@pervasive.com
Subject: Re: Firebird 1.5.3 X Postgresql 8.1.3 (linux and windows)
In-Reply-To: <1147514282.3896.12.camel@localhost.localdomain>
* 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