Re: slow joining very large table to smaller ones

From: Michael Stone <mstone+postgres(at)mathom(dot)us>
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-14 22:47:46
Message-ID: 20050714224746.GD19080@mathom.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Thu, Jul 14, 2005 at 04:29:58PM -0600, Dan Harris 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.

Try running the query as a script with nohup & redirect the output to a
file.

Mike Stone

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2005-07-14 23:08:43 Re: slow joining very large table to smaller ones
Previous Message John A Meinel 2005-07-14 22:46:09 Re: slow joining very large table to smaller ones