Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group