Re: Identical Queries

Поиск
Список
Период
Сортировка
От Chad Wagner
Тема Re: Identical Queries
Дата
Msg-id 81961ff50703011309v43c0974eie31172e36f8460cd@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Identical Queries  (Rob Schall <rschall@callone.net>)
Список pgsql-performance
Дерево обсуждения
On 3/1/07, Rob Schall <rschall@callone.net> wrote:
There are 4 entries (wanted to make the playing field level for this
test). There are 2 with true for istf and 2 with false.

Then the difference here has to do with using orignum vs destnum as the join criteria.  There must be more intersections for orignum than destnum, or your statistics are so far out of whack.  It appears to be estimating 5M vs 500K for a result set, and naturally it chose a different plan.

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

Предыдущее
От: "Alex Deucher"
Дата:
Сообщение: Re: strange performance regression between 7.4 and 8.1
Следующее
От: "Alex Deucher"
Дата:
Сообщение: Re: strange performance regression between 7.4 and 8.1