Getting rid of nested loop

Поиск
Список
Период
Сортировка
От Rod Taylor
Тема Getting rid of nested loop
Дата
Msg-id 1096073834.40463.41.camel@jester
обсуждение исходный текст
Список pgsql-performance
I set nested_loop = off, which is why I have the high cost.

@ is a postgis operator between 2 geomotries (both polygons). It's the @
operator which is expensive. Is there a way to force a cheaper way of
doing that join?

         ->  Nested Loop  (cost=100001905.94..100001906.08 rows=1
width=68) (actual time=1739.368..17047.422 rows=100 loops=1)
               Join Filter: ((COALESCE("outer".geom, "outer".geom) @
COALESCE("inner".geom, "inner".geom)) AND ("outer".region_id <>
"inner".region_id))



В списке pgsql-performance по дате отправления: