pgsql: Load FK defs into relcache for use by planner

Started by Simon Riggsover 10 years ago2 messagescomitters
Jump to latest
#1Simon Riggs
simon@2ndQuadrant.com

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

--
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers

In reply to: Simon Riggs (#1)
Re: pgsql: Load FK defs into relcache for use by planner

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

--
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers