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 1117.1233092522@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>)
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 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

pgsql-general by date:

Previous
From: Jeff Davis
Date:
Subject: Re: Fwd: Re: New 8.4 hot standby feature
Next
From: Karsten Hilbert
Date:
Subject: Re: performance advice needed: join vs explicit subselect