Nested Loop (cost=0.00..147.11 rows=1 width=148) (actual time=84.00..12323.00 rows=67 loops=1)
The planner estimate doesn't seem to match reality in that particular step. Are you sure you've run:
ANALYZE oscar_node; ANALYZE oscar_point;
And you could even run VACUUM FULL on them just to make sure.
Does that make any difference?
Chris
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
