pgsql: Redo postgres_fdw's planner code so it can handle parameterized

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Redo postgres_fdw's planner code so it can handle parameterized
Date: 2013-03-21 23:44:41
Message-ID: E1UIpA1-0003qS-K2@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Redo postgres_fdw's planner code so it can handle parameterized paths.

I wasn't going to ship this without having at least some example of how
to do that. This version isn't terribly bright; in particular it won't
consider any combinations of multiple join clauses. Given the cost of
executing a remote EXPLAIN, I'm not sure we want to be very aggressive
about doing that, anyway.

In support of this, refactor generate_implied_equalities_for_indexcol
so that it can be used to extract equivalence clauses that aren't
necessarily tied to an index.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/9cbc4b80ddc10b36c64514104caa69747c386dcf

Modified Files
--------------
contrib/postgres_fdw/deparse.c | 399 ++++++----
contrib/postgres_fdw/expected/postgres_fdw.out | 23 +-
contrib/postgres_fdw/postgres_fdw.c | 941 +++++++++++++++---------
contrib/postgres_fdw/postgres_fdw.h | 11 +-
contrib/postgres_fdw/sql/postgres_fdw.sql | 4 +
src/backend/optimizer/path/equivclass.c | 35 +-
src/backend/optimizer/path/indxpath.c | 41 +-
src/include/optimizer/paths.h | 18 +-
8 files changed, 919 insertions(+), 553 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2013-03-22 04:31:30 pgsql: Avoid retrieving dummy NULL columns in postgres_fdw.
Previous Message Dimitri Fontaine 2013-03-21 20:27:25 Re: [COMMITTERS] pgsql: Fix "element <@ range" cost estimation.