Re: Performance trouble finding records through related records

From: sverhagen <sverhagen(at)wps-nl(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Performance trouble finding records through related records
Date: 2011-03-08 11:31:43
Message-ID: 1299583903805-3413814.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


Merlin Moncure-2 wrote:
>
>
> 8.3? try converting the above to WHERE EXISTS or (even better) a JOIN...
>
>

Thanks for that. But in my Mar 03, 2011; 10:19am post I already broke it
down to the barebones with some variations, among which JOIN. The EXISTS IN
variation was so poor that I left that one out.

Best regards, Sander.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Performance-trouble-finding-records-through-related-records-tp3405914p3413814.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Andy Colson 2011-03-08 15:21:37 Re: Performance issues
Previous Message sverhagen 2011-03-08 11:17:42 Re: Performance trouble finding records through related records