Re: performance advice needed: join vs explicit subselect

Karsten Hilbert <Karsten.Hilbert@gmx.net> writes:
> The view in question is in fact a lot more complicated. This
> is the best I've been able to come up with so far (and it is
> still slow - slow as in 3-4 seconds for 20 records out of
> (currently only) 50 !):

What does EXPLAIN ANALYZE say about it?  Also, what is the use-case
you are concerned about --- selecting the whole view contents, or
selecting WHERE something-or-other?

            regards, tom lane