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 499D552ADF for ; Fri, 15 Jul 2005 13:44: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 12499-02 for ; Fri, 15 Jul 2005 16:44:32 +0000 (GMT) Received: from wolff.to (wolff.to [66.93.197.194]) by svr1.postgresql.org (Postfix) with SMTP id B6B50528DD for ; Fri, 15 Jul 2005 13:44:28 -0300 (ADT) Received: (qmail 783 invoked by uid 500); 15 Jul 2005 16:44:58 -0000 Date: Fri, 15 Jul 2005 11:44:58 -0500 From: Bruno Wolff III To: Dan Harris Cc: pgsql-performance@postgresql.org Subject: Re: slow joining very large table to smaller ones Message-ID: <20050715164458.GA26178@wolff.to> Mail-Followup-To: Bruno Wolff III , Dan Harris , pgsql-performance@postgresql.org References: <46AF8F35-B735-4DFA-BA0A-AC82B5DA3CCE@drivefaster.net> <42D687E5.7080202@arbash-meinel.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.007 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200507/219 X-Sequence-Number: 13460 On Thu, Jul 14, 2005 at 16:29:58 -0600, Dan Harris wrote: > > 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. Are you using NAT at home? That's probably where the issue is. If you have control of that box you can probably increase the timeout to a couple of hours.