Turn correlated in subquery into join - Mailing list pgsql-performance

From Dennis Bjorklund
Subject Turn correlated in subquery into join
Date
Msg-id 47E7567C.1090804@zigo.dhs.org
Whole thread Raw
Responses Re: Turn correlated in subquery into join  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Look like the mysql people found a subquery that postgresql doesn't
handle as good as possible:

   http://s.petrunia.net/blog/

Is there some deeper issue here that I fail to see or is it simply that
it hasn't been implemented but is fairly straigt forward? In the link
above they do state that it isn't a very common case anyway.

/Dennis

pgsql-performance by date:

Previous
From:
Date:
Subject: slow pg_connect()
Next
From: Craig Ringer
Date:
Subject: Re: slow pg_connect()