stange optimizer results

Поиск
Список
Период
Сортировка
От Peter T. Brown
Тема stange optimizer results
Дата
Msg-id 1037902735.1784.22.camel@localhost.localdomain
обсуждение исходный текст
Ответ на vacuum full  ("Henrik Steffen" <steffen@city-map.de>)
Ответы Re: stange optimizer results  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Список pgsql-performance
Hello--

Attached is a file containing two SQL queries. The first take
prohibitively long to complete because, according to EXPLAIN, it ignore
two very important indexes. The second SQL query seems almost identical
to the first but runs very fast because, according to EXPLAIN, it does
uses all the indexes appropriately.

Can someone please explain to me what the difference is here? Or if
there is something I can do with my indexes to make the first query run
like the second?


Thanks Much

Peter

Вложения

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

Предыдущее
От: "Charles H. Woloszynski"
Дата:
Сообщение: Re: H/W RAID 5 on slower disks versus no raid on faster
Следующее
От: "scott.marlowe"
Дата:
Сообщение: Re: H/W RAID 5 on slower disks versus no raid on faster