On Thu, Jul 17, 2014 at 6:18 PM, Peter Geoghegan <p...@heroku.com> wrote: > This appears to be a Simple Matter of Programming (at least > for someone that happens to already have a good understanding of the > optimizer), and is anticipated by this comment within tidpath.c: > > * There is currently no special support for joins involving CTID; in > * particular nothing corresponding to best_inner_indexscan(). Since it's > * not very useful to store TIDs of one table in another table, there > * doesn't seem to be enough use-case to justify adding a lot of code > * for that.
By the way, this comment is obsolete since best_inner_indexscan() was removed in 2012 by the parameterized paths patch. -- Peter Geoghegan -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers