> Tatsuo Ishii <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
