On Thu, Jul 14, 2005 at 16:29:58 -0600,
Dan Harris <fbsd(at)drivefaster(dot)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.
In response to
pgsql-performance by date
|Next:||From: PFC||Date: 2005-07-15 17:39:30|
|Subject: Re: slow joining very large table to smaller ones|
|Previous:||From: Dennis||Date: 2005-07-15 16:03:12|
|Subject: Re: performance problems ... 100 cpu utilization|