X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 40D77D1B211 for ; Mon, 7 Jun 2004 20:32:46 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 00623-04 for ; Mon, 7 Jun 2004 23:32:20 +0000 (GMT) Received: from correo2.lamundial.hn (mail.lamundial.hn [200.62.45.82]) by svr1.postgresql.org (Postfix) with ESMTP id 81E6CD1B265 for ; Mon, 7 Jun 2004 20:32:00 -0300 (ADT) Received: from lamundial.hn (computo [192.168.0.140]) by correo2.lamundial.hn (8.12.11/linuxconf) with ESMTP id i57NPu3U001275; Mon, 7 Jun 2004 17:25:57 -0600 Message-ID: <40C4FA85.8070205@lamundial.hn> Date: Mon, 07 Jun 2004 17:30:13 -0600 From: =?ISO-8859-1?Q?Josu=E9_Maldonado?= User-Agent: Mozilla Thunderbird 0.5 (Windows/20040207) X-Accept-Language: en-us, en MIME-Version: 1.0 To: josh@agliodbs.com Cc: pgsql-performance@postgresql.org Subject: Re: Join slow on "large" tables References: <40C4E9EA.7000708@lamundial.hn> <200406071531.49207.josh@agliodbs.com> <40C4F66C.8030609@lamundial.hn> <200406071621.10732.josh@agliodbs.com> In-Reply-To: <200406071621.10732.josh@agliodbs.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200406/81 X-Sequence-Number: 7139 Josh, El 07/06/2004 5:21 PM, Josh Berkus en su mensaje escribio: > > Huh? It is not at all the same. Your index scan is down to 87ms from > 27,000! And the total query is down to 16seconds from 47 seconds. Don't > you consider that an improvement? Yes there was an improvement with respect the previus query, but still 16 seconds is too slow for that query. And usually the query takes more than 10 seconds even with small data sets returned. Thanks, -- Sinceramente, Josué Maldonado. "La cultura es capaz de descifrar los enigmas en que nos envuelve la vida."