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 447FED1D69B for ; Wed, 11 Feb 2004 17:15:28 +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 04547-09 for ; Wed, 11 Feb 2004 13:15:13 -0400 (AST) Received: from servidor5.servidorbr.net (unknown [69.57.128.78]) by svr1.postgresql.org (Postfix) with ESMTP id 3D971D1DA5F for ; Wed, 11 Feb 2004 13:15:14 -0400 (AST) Received: from cpanel by servidor5.servidorbr.net with local (Exim 4.24) id 1AqxxB-0003Vx-SZ; Wed, 11 Feb 2004 15:15:13 -0200 Received: from 200.207.205.140 ([200.207.205.140]) by tiago.hazor.com.br (IMP) with HTTP for ; Wed, 11 Feb 2004 15:15:13 -0200 Message-ID: <1076519713.402a6321be75d@tiago.hazor.com.br> Date: Wed, 11 Feb 2004 15:15:13 -0200 From: alemon@tiago.hazor.com.br To: Tom Lane Cc: Postgresql Performance Subject: Re: slow database References: <1076509411.402a3ae38d9b8@tiago.hazor.com.br> <1076510965.761.17.camel@jester> <1076516201.402a556a176d1@tiago.hazor.com.br> <22126.1076518828@sss.pgh.pa.us> In-Reply-To: <22126.1076518828@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit User-Agent: Internet Messaging Program (IMP) 3.2.1 X-Originating-IP: 200.207.205.140 X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - servidor5.servidorbr.net X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [32001 502] / [47 12] X-AntiAbuse: Sender Address Domain - tiago.hazor.com.br X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/135 X-Sequence-Number: 5659 I already came back the old conditions and I continue slow in the same way! Quoting Tom Lane : > alemon@tiago.hazor.com.br writes: > > the normal queries do not present problems, but all the ones > > that join has are very slow. > > No surprise, as you've disabled all but the stupidest join algorithm... > > As others already pointed out, you'd be a lot better off with the > default configuration settings than with this set. > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 8: explain analyze is your friend > >