rows=177023872 width=48) (actual
time=22.064..617462.486 rows=177757299 loops=1)
-> Index Scan using xmmbox on xmm1 x (cost=0.00..1107.28 rows=280 width=48)
(actual time=0.036..0.036 rows=0 loops=177757299)
Index Cond: (x.errbox && "outer".errbox)
Total runtime
his 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
an outer join
should be faster than an inner one, or to put it another way, after
dropping an index there is more than an order of magnitude speed increase.
I'm using Postgres 7.4.1 on Red Hat Linux. Has anyone had similar
problems with spatial joins?
--
Cl
ld be implemented in some more efficient
way.
--
Clive Page,
Dept of Physics & Astronomy,
University of Leicester, U.K.
---(end of broadcast)---
TIP 8: explain analyze is your friend
