Re: Another optimizer question

> > If I do a view that produces the data I want through joins, it takes
hours,
> > even with all fields indexed, and after VACUUM ANALYZE. Doing SET
ENABLE
> > SEQ_SCAN = OFF doesn't seem to make any difference. The query plan
changes,
> > but select times are still roughly the same... Doing the separate
> > subqueries on each table and joining data manualy in the application
code
> > takes literaly seconds.
>
> Um, have you updated since I changed the subselect-restriction
> processing two days ago?

Not yet. I've done it in appliction code for now. I'll try again in
straight SQL when the next beta or release are available.

Thanks.

Gordan