"Gordan Bobic" <gordan(at)freeuk(dot)com> writes:
> 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?
regards, tom lane