Re: Subquery in a JOIN not getting restricted?

From: Jay Levitt <jay(dot)levitt(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, Merlin Moncure <mmoncure(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Subquery in a JOIN not getting restricted?
Date: 2011-11-10 15:42:53
Message-ID: 4EBBF0FD.5050506@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Rafael Martinez 2011-11-11 09:54:11 Re: WAL partition filling up after high WAL activity
Previous Message Tom Lane 2011-11-10 15:22:48 Re: Subquery in a JOIN not getting restricted?