Re: [HACKERS] Case statement ready? - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] Case statement ready?
Date
Msg-id 199812041636.LAA18456@candle.pha.pa.us
Whole thread Raw
In response to Re: [HACKERS] Case statement ready?  ("Thomas G. Lockhart" <lockhart@alumni.caltech.edu>)
List pgsql-hackers
> If anyone has a chance to look at the new code wrt the rewriter and
> optimizer costing that would be great. For the costing I would assume
> that the cost should be related to the sum of the costs of the
> individual clauses within the CASE statement (or maybe half of the sum).

Isn't only one of the case values going to be used?  Wouldn't you want
the average of the case entry costs?

--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: "Thomas G. Lockhart"
Date:
Subject: Re: [HACKERS] Date/time on glibc2 linux
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] exp() changes