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 2595752BE9 for ; Fri, 15 Jul 2005 14:39:44 -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 73174-05 for ; Fri, 15 Jul 2005 17:39:35 +0000 (GMT) Received: from boutiquenumerique.com (boutiquenumerique.com [82.67.9.10]) by svr1.postgresql.org (Postfix) with ESMTP id E8F3252B13 for ; Fri, 15 Jul 2005 14:39:34 -0300 (ADT) Received: (qmail 25483 invoked from network); 15 Jul 2005 19:40:05 +0200 Received: from unknown (HELO localhost) (boutiquenumerique-lists@192.168.0.4) by boutiquenumerique.com with SMTP; 15 Jul 2005 19:40:05 +0200 To: "Bruno Wolff III" , "Dan Harris" Cc: pgsql-performance@postgresql.org Subject: Re: slow joining very large table to smaller ones References: <46AF8F35-B735-4DFA-BA0A-AC82B5DA3CCE@drivefaster.net> <42D687E5.7080202@arbash-meinel.com> <20050715164458.GA26178@wolff.to> Message-ID: From: PFC Organization: =?iso-8859-15?Q?La_Boutique_Num=E9rique?= Content-Type: text/plain; format=flowed; delsp=yes; charset=iso-8859-15 MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Date: Fri, 15 Jul 2005 19:39:30 +0200 In-Reply-To: <20050715164458.GA26178@wolff.to> User-Agent: Opera M2/8.0 (Linux, build 1095) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.005 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200507/220 X-Sequence-Number: 13461 >> Ok, I tried this one. My ssh keeps getting cut off by a router >> somewhere between me and the server due to inactivity timeouts, so >> all I know is that both the select and explain analyze are taking >> over an hour to run. Here's the explain select for that one, since >> that's the best I can get. one word : screen ! one of the most useful little command line utilities...