Re: slow joining very large table to smaller ones

From: PFC <lists(at)boutiquenumerique(dot)com>
To: "Bruno Wolff III" <bruno(at)wolff(dot)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 17:39:30
Message-ID: op.stytz41xth1vuj@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


>> 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.

one word : screen !
one of the most useful little command line utilities...

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Ron Wills 2005-07-15 20:39:36 Really bad diskio
Previous Message Bruno Wolff III 2005-07-15 16:44:58 Re: slow joining very large table to smaller ones