Re: [HACKERS] selectivity calculation for or_clause is wrong ?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [HACKERS] selectivity calculation for or_clause is wrong ?
Дата
Msg-id 17571.933445570@sss.pgh.pa.us
обсуждение исходный текст
Ответ на RE: [HACKERS] selectivity calculation for or_clause is wrong ?  ("Hiroshi Inoue" <Inoue@tpf.co.jp>)
Список pgsql-hackers
Дерево обсуждения 
"Hiroshi Inoue" <Inoue@tpf.co.jp> writes:
>>>> Why is valid_or_clause(clausenode) necessary ?
>> 
>> Looks like a waste of cycles to me too.
>
> It's not only a waste of cycles.
> [ snip ]
> rows of each plan  261 : 773 : 1274  not =  1 : 2 : 3.
> It's nearly = 1 :3 :5.
> elements of or_clause except its first element are evaluated 
> twice and the results are accumlated.

BTW, I fixed this...
        regards, tom lane

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

Предыдущее
От: Mike Mascari
Дата:
Сообщение: Re: [HACKERS] IPC Memory problem with Postmaster on BSDi 4.x
Следующее
От: Roberth Andersson
Дата:
Сообщение: Re: [HACKERS] IPC Memory problem with Postmaster on BSDi 4.x