On 16 Feb, Tom Lane wrote:
> markw@osdl.org writes:
>> It looks like we have indexes on all of the date columns except
>> l_commitdate, which appears to be in Q4.
>
>> So I think I'll run against the CVS tip as is, again with an index on
>> l_commitdate, and then another test to confirm your theory. Sound good?
>
> Sure, it's only cycles ;-). I am not certain that an index on
> commitdate would help any, but it's worth trying.
http://developer.osdl.org/markw/dbt3-pgsql/70/
Those are results from a pull from CVS I did this morning.
I reverted Q4 (removed the CAST), but the extra WHERE constraints are
still in Q21.
Mark