Re: performance advice needed: join vs explicit subselect

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: performance advice needed: join vs explicit subselect
Date: 2009-01-27 21:42:02
Message-ID: 1117.1233092522@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Karsten Hilbert 2009-01-27 21:55:34 Re: performance advice needed: join vs explicit subselect
Previous Message Jeff Davis 2009-01-27 21:25:44 Re: Fwd: Re: New 8.4 hot standby feature