Turn correlated in subquery into join

From: Dennis Bjorklund <db(at)zigo(dot)dhs(dot)org>
To: PostgreSQL Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Turn correlated in subquery into join
Date: 2008-03-24 07:21:32
Message-ID: 47E7567C.1090804@zigo.dhs.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message firerox 2008-03-24 07:40:15 slow pg_connect()
Previous Message Tom Lane 2008-03-23 15:28:52 Re: Views and functions returning sets of records