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?


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

Reply via email to