X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 41C13D1C4B9 for ; Sun, 27 Jul 2003 13:32:11 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 11118-07 for ; Sun, 27 Jul 2003 10:31:21 -0300 (ADT) Received: from unimm.unisoftbg.com (unknown [194.12.229.207]) by svr1.postgresql.org (Postfix) with ESMTP id 57DEED1C4B7 for ; Sun, 27 Jul 2003 10:29:24 -0300 (ADT) Received: (qmail 2154 invoked by uid 507); 27 Jul 2003 13:30:24 -0000 Received: from unknown (HELO t1.unisoftbg.com) (pginfo%t1.unisoftbg.com@194.12.229.193) by 0 with SMTP; 27 Jul 2003 13:30:24 -0000 Message-ID: <3F23C418.5CC6D754@t1.unisoftbg.com> Date: Sun, 27 Jul 2003 14:22:48 +0200 From: pginfo X-Mailer: Mozilla 4.03 [en] (Win95; I) MIME-Version: 1.0 To: Bruno BAGUETTE Cc: pgsql-performance@postgresql.org Subject: Re: RE : Query problem References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/433 X-Sequence-Number: 2726 Hi Bruno, I think I have tunet it. Pg is working for most of my selects, but I have problem with this one. regards, ivan Bruno BAGUETTE wrote: > Hello, > > > One of my selects is working much slower as in oracle. > > In this example I am using not many rows in tables. > > For all the joins I have indexes. > > All IDS or IDS_xxx are name. > > > > Pls if it is possible poit me how to fix this problem. > > > > I send the query and the explai analyze. > > I have ran vacuum analyze full on db. > > Have you tuned your postgresql.conf settings ? > > The PostgreSQL default settings are very low in order to allow > PostgreSQL to RUN on old machines and new machines. If you need > PERFORMANCE (which is quite logic), you must setup the postgresql.conf > file. > > Here's a nice article about the postgresql.conf file tuning : > http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html > > Hope this help ! :-) > > Cheers, > > --------------------------------------- > Bruno BAGUETTE - pgsql-ml@baguette.net