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.