X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 25BF49F9430 for ; Fri, 12 May 2006 11:49:33 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 87027-04-5 for ; Fri, 12 May 2006 11:49:21 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id EC25C9FA4EA for ; Fri, 12 May 2006 11:49:20 -0300 (ADT) Received: from techforce.com.br (techforce.com.br [216.218.247.150]) by svr4.postgresql.org (Postfix) with ESMTP id 80FC45B57E5 for ; Fri, 12 May 2006 14:48:43 +0000 (GMT) Received: from techforce.com.br (techforce.com.br [127.0.0.1]) by techforce.com.br (8.12.11/8.12.11) with ESMTP id k4CEmqoV024414 for ; Fri, 12 May 2006 07:48:52 -0700 From: "andremachado" 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> X-Mailer: Open WebMail 2.51 20050228 X-OriginatingIP: 161.148.33.118 (andremachado@techforce.com.br) MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/326 X-Sequence-Number: 19113 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