>>> On Fri, Sep 21, 2007 at 12:30 PM, in message
<[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
wrote: 
 
> This is the plan for the old server:
> Hash Join  (cost=449.55..8879.24 rows=136316 width=904) (actual 
> time=50.734..1632.491 rows=136316 loops=1)
. . .
> Total runtime: 2022.293 ms
 
> And this is the plan for the new server:
> Hash Join  (cost=412.86..9524.13 rows=136316 width=905) (actual 
> time=9.421..506.376 rows=136316 loops=1)
. . .
> Total runtime: 553.619 ms
 
> I see an "outer" join in the plan for the new server. This is weird!!! There 
> are the same databases in both servers.
 
That's just a matter of labeling the tables with role rather than alias.
The plans look the same to me.
 
> The old one runs this query for about 37 seconds and for the new one for 
> about 301 seconds.
 
That's not what it looks like based on the EXPLAIN ANALYZE output.
It looks like run time dropped from two seconds to half a second.
 
It seems as though you either have a network delay delivering the results,
or your application is slow to read them.

Exactly how are you arriving at those timings you're reporting to us?
 
-Kevin
 



---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Reply via email to