Re: [HACKERS] selectivity calculation for or_clause is wrong ?
Started by Tom Laneover 26 years ago1 messageshackers
"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
Import Notes
Reply to msg id not found: YourmessageofWed21Jul1999103158+0900000301bed318d2fca0c02801007e@cadzone.tpf.co.jp