Request a Demo
Home   >   mailing lists

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

From PFC
Subject Re: slow joining very large table to smaller ones
Date
Msg-id op.stytz41xth1vuj@localhost
Whole thread Raw
In response to Re: slow joining very large table to smaller ones  (Bruno Wolff III <[email protected]>)
List pgsql-performance
Tree view 
>> 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...

pgsql-performance by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: slow joining very large table to smaller ones
Next
From: Ron Wills
Date:
Subject: Really bad diskio