Re: [GENERAL] Another optimizer question

[Tom Lane]

"Gordan Bobic" <[EMAIL PROTECTED]> 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