| From: | markw(at)osdl(dot)org |
|---|---|
| To: | tgl(at)sss(dot)pgh(dot)pa(dot)us |
| Cc: | josh(at)agliodbs(dot)com, pgsql-hackers(at)postgresql(dot)org, jenny(at)osdl(dot)org |
| Subject: | Re: Proposed Query Planner TODO items |
| Date: | 2004-02-16 23:41:07 |
| Message-ID: | 200402162341.i1GNfDE15442@mail.osdl.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 16 Feb, Tom Lane wrote:
> markw(at)osdl(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christopher Kings-Lynne | 2004-02-17 01:15:46 | Re: [PATCHES] dollar quoting |
| Previous Message | Simon Riggs | 2004-02-16 23:07:25 | Re: Proposals for PITR |