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 по дате отправления:

Предыдущее
От: Qing Zhao
Дата:
Сообщение: performance of PostgreSQL on 64 bit MAC OS X G5!
Следующее
От: Gaetano Mendola
Дата:
Сообщение: Re: Caching of Queries