| From: | Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp> |
|---|---|
| To: | tgl(at)sss(dot)pgh(dot)pa(dot)us |
| Cc: | markw(at)osdl(dot)org, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: DBT-3 v1.5 Q19 |
| Date: | 2004-11-04 15:17:18 |
| Message-ID: | 20041105.001718.45516682.t-ishii@sra.co.jp |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp> writes:
> >> Just for quick note, it seems query 19 takes forever. Have you
> >> successfully run Q19?
>
> > Here is the more detailed info. The query was not finished within 3
> > days and was canceled on a Dual Xeon 2.8GHz with 2.5GB RAM running
> > Linux. PostgreSQL is 7.4.5 with default postgresql.conf.
>
> 7.4's planner is not able to do anything useful with the complicated
> WHERE clause in Q19. I believe I've improved that situation for 8.0.
> A really slick solution will probably have to await the appearance of
> bitmap indexes, though.
Thanks. I will try with 8.0.
--
Tatsuo Ishii
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Sullivan | 2004-11-04 15:29:54 | Re: Vacuum and oldest xmin (again) |
| Previous Message | Tom Lane | 2004-11-04 15:08:32 | Re: DBT-3 v1.5 Q19 (Re: Proposed Query Planner TODO items) |