Re: Spatial join insists on sequential scan of larger

Поиск
Список
Период
Сортировка
От Clive Page
Тема Re: Spatial join insists on sequential scan of larger
Дата
Msg-id Pine.LNX.4.44L0.0404021700370.2713-100000@peneca.star.le.ac.uk
обсуждение исходный текст
Ответ на Re: Spatial join insists on sequential scan of larger table  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
Дерево обсуждения 
On Fri, 2 Apr 2004, Tom Lane wrote:

> Could we see EXPLAIN ANALYZE output?

Certainly, but that's going to take a little time (as the ANALYZE causes
it to run the actual query, which I only just discovered), so may have to
wait until Monday if I don't get time to finish it this afternoon.


--
Clive Page
Dept of Physics & Astronomy,
University of Leicester,
Leicester, LE1 7RH,  U.K.

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

Предыдущее
От: Bruno Wolff III
Дата:
Сообщение: Re: single index on more than two coulumns a bad thing?
Следующее
От: "Gary Doades"
Дата:
Сообщение: Re: PostgreSQL and Linux 2.6 kernel.