Re: performance advice needed: join vs explicit subselect - Mailing list pgsql-general

From Tom Lane
Subject Re: performance advice needed: join vs explicit subselect
Date
Msg-id 2047.1233095423@sss.pgh.pa.us
Whole thread Raw
In response to Re: performance advice needed: join vs explicit subselect  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
Responses Re: performance advice needed: join vs explicit subselect  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
List pgsql-general
Karsten Hilbert <Karsten.Hilbert@gmx.net> writes:
> the explain analyze of which is (I've actually gotten it to
> work better in the meantime as you can see):

Looks like most of the problem is in the subquery scans on v_staff,
which seems to be a rather expensive view :-(.  Maybe you can
simplify that a bit.

            regards, tom lane

pgsql-general by date:

Previous
From: Karsten Hilbert
Date:
Subject: Re: performance advice needed: join vs explicit subselect
Next
From: Karsten Hilbert
Date:
Subject: Re: performance advice needed: join vs explicit subselect