Re: slow joining very large table to smaller ones

On Thu, Jul 14, 2005 at 16:29:58 -0600,
  Dan Harris <fbsd@drivefaster.net> 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.