Re: slow joining very large table to smaller ones

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Dan Harris <fbsd(at)drivefaster(dot)net>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: slow joining very large table to smaller ones
Date: 2005-07-15 16:44:58
Message-ID: 20050715164458.GA26178@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message PFC 2005-07-15 17:39:30 Re: slow joining very large table to smaller ones
Previous Message Dennis 2005-07-15 16:03:12 Re: performance problems ... 100 cpu utilization