Request a Demo
Home   >   mailing lists

Re: [HACKERS] selectivity calculation for or_clause is wrong ? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [HACKERS] selectivity calculation for or_clause is wrong ?
Date
Msg-id [email protected]
Whole thread Raw
In response to selectivity calculation for or_clause is wrong ?  ("Hiroshi Inoue" <[email protected]>)
Responses RE: [HACKERS] selectivity calculation for or_clause is wrong ?
List pgsql-hackers
Tree view 
"Hiroshi Inoue" <[email protected]> writes:
> Why is valid_or_clause(clausenode) necessary ?

Looks like a waste of cycles to me too.

If the subclauses of an OR could get rearranged during optimization
then this might be a necessary check, but AFAIK they don't.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [SQL] Re: [HACKERS] Counting bool flags in a complex query
Next
From: "Ansley, Michael"
Date:
Subject: RE: [HACKERS] psql & query string length