X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 27205D1B4FE for ; Wed, 12 Nov 2003 15:44:12 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 08763-08 for ; Wed, 12 Nov 2003 11:43:45 -0400 (AST) Received: from spirit.aldeiadigital.com.br (iplus-fac-225-213-137.xdsl-fixo.ctbcnetsuper.com.br [200.225.213.137]) by svr1.postgresql.org (Postfix) with ESMTP id 7574ED1B537 for ; Wed, 12 Nov 2003 11:43:35 -0400 (AST) Received: from webmail.ad2.com.br (localhost.localdomain [127.0.0.1]) by spirit.aldeiadigital.com.br (8.11.6/8.11.6) with SMTP id hACFf3715458 for ; Wed, 12 Nov 2003 13:41:03 -0200 Received: from 192.168.1.120 (SquirrelMail authenticated user alepaes) by webmail.ad2.com.br with HTTP; Wed, 12 Nov 2003 13:41:03 -0200 (BRST) Message-ID: <2834.192.168.1.120.1068651663.squirrel@webmail.ad2.com.br> Date: Wed, 12 Nov 2003 13:41:03 -0200 (BRST) Subject: Superior performance in PG 7.4 From: "alexandre :: aldeia digital" To: pgsql-performance@postgresql.org User-Agent: SquirrelMail/1.4.0 MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-1 X-Priority: 3 Importance: Normal X-Virus-Scanned: by amavisd-milter (http://amavis.org/) X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/64 X-Sequence-Number: 4624 Hi, I am trying the PG 7.4 RC1 and RC2 and I see a superb performance improvement compared with 7.3.... Explaining the querys, I see a change of planner that, in my case, prefer Nested Loops in 7.4 opposite to Hash or Merge Join in 7.3. To test, I disable Hash and Merge Joins in 7.3 and performance have been very improved using nested loops... Both systems are identical in configurations, properly vacuuned and analyzed before tests. Something can be wrong with my tests ? [ I desire that not :) ] Alexandre