Re: [PERFORM] Spatial join insists on sequential scan of larger table
Clive Page [EMAIL PROTECTED] writes: This executes, it need hardly be said, a whole lot faster. Could we see EXPLAIN ANALYZE output? The estimated costs for the two cases are nearly the same, which says to me that there's something wrong with the cost model for r-tree lookups, but I don't know what it is. regards, tom lane ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [PERFORM] Spatial join insists on sequential scan of larger
On Fri, 2 Apr 2004, Tom Lane wrote: Could we see EXPLAIN ANALYZE output? Certainly, but that's going to take a little time (as the ANALYZE causes it to run the actual query, which I only just discovered), so may have to wait until Monday if I don't get time to finish it this afternoon. -- Clive Page Dept of Physics Astronomy, University of Leicester, Leicester, LE1 7RH, U.K. ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings