Thread: pgsql: Load FK defs into relcache for use by planner

pgsql: Load FK defs into relcache for use by planner

From
Simon Riggs
Date:
Load FK defs into relcache for use by planner

Fastpath ignores this if no triggers defined.

Author: Tomas Vondra, with fastpath and comments added by me
Reviewers: David Rowley, Simon Riggs

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/015e88942aa50f0d419ddac00e63bb06d6e62e86

Modified Files
--------------
src/backend/nodes/outfuncs.c         | 13 ++++++
src/backend/optimizer/util/plancat.c | 85 +++++++++++++++++++++++++++++++++++-
src/backend/utils/cache/relcache.c   | 75 +++++++++++++++++++++++++++++++
src/include/nodes/nodes.h            |  1 +
src/include/nodes/relation.h         | 22 ++++++++++
src/include/utils/rel.h              |  3 ++
src/include/utils/relcache.h         |  1 +
7 files changed, 199 insertions(+), 1 deletion(-)


Re: pgsql: Load FK defs into relcache for use by planner

From
Peter Geoghegan
Date:
On Thu, Apr 7, 2016 at 4:09 AM, Simon Riggs <simon@2ndquadrant.com> wrote:
> Load FK defs into relcache for use by planner

I gather this is infrastructure for the "use foreign keys to improve
join estimates" patch. A more worked out commit message would be nice,
though.


--
Peter Geoghegan