Re: Subquery in a JOIN not getting restricted? - Mailing list pgsql-performance

From Jay Levitt
Subject Re: Subquery in a JOIN not getting restricted?
Date
Msg-id 4EBBF0FD.5050506@gmail.com
Whole thread Raw
In response to Re: Subquery in a JOIN not getting restricted?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
> Don't hold your breath waiting for that to change.  To do what you're
> wishing for, we'd have to treat the GROUP BY subquery as if it were an
> inner indexscan, and push a join condition into it.  That's not even
> possible today.

Thanks! Knowing "that's not a thing" helps; we'll just have to rephrase the
query.

Jay

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Subquery in a JOIN not getting restricted?
Next
From: kzsolt
Date:
Subject: Re: Heavy contgnous load