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(-)
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. |