Re: Identical Queries

Поиск
Список
Период
Сортировка
От Stephan Szabo
Тема Re: Identical Queries
Дата
Msg-id 20070301142004.J53183@megazone.bigpanda.com
обсуждение исходный текст
Ответ на Re: Identical Queries  (Rob Schall <rschall@callone.net>)
Список pgsql-performance
On Thu, 1 Mar 2007, Rob Schall 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 analyzing might help, because I think it's estimating many more rows
for both cases, and with 2 rows estimated to be returned the nested loop
should seem a lot more attractive than at 900+.

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

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