Re: slow joining very large table to smaller ones - Mailing list pgsql-performance

From Bruno Wolff III
Subject Re: slow joining very large table to smaller ones
Date
Msg-id 20050715164458.GA26178@wolff.to
Whole thread Raw
In response to Re: slow joining very large table to smaller ones  (Dan Harris <fbsd@drivefaster.net>)
Responses Re: slow joining very large table to smaller ones  (PFC <lists@boutiquenumerique.com>)
Re: slow joining very large table to smaller ones  (Dawid Kuroczko <qnex42@gmail.com>)
List pgsql-performance
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.

pgsql-performance by date:

Previous
From: Dennis
Date:
Subject: Re: performance problems ... 100 cpu utilization
Next
From: PFC
Date:
Subject: Re: slow joining very large table to smaller ones