pgsql: Remove derived fields from RI_QueryKey, and do a bit of other cl - Mailing list pgsql-committers

From Tom Lane
Subject pgsql: Remove derived fields from RI_QueryKey, and do a bit of other cl
Date
Msg-id E1Sgkml-0005f3-Oa@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Remove derived fields from RI_QueryKey, and do a bit of other cleanup.

We really only need the foreign key constraint's OID and the query type
code to uniquely identify each plan we are caching for FK checks.  The
other stuff that was in the struct had no business being used as part of
a hash key, and was all just being copied from struct RI_ConstraintInfo
anyway.  Get rid of the unnecessary fields, and readjust various function
APIs to make them use RI_ConstraintInfo not RI_QueryKey as info source.

I'd be surprised if this makes any measurable performance difference,
but it certainly feels cleaner.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/03a5ba24b096a9acbbc9682adc0a27d1db31c570

Modified Files
--------------
src/backend/utils/adt/ri_triggers.c |  458 +++++++++++++++--------------------
1 files changed, 194 insertions(+), 264 deletions(-)


pgsql-committers by date:

Previous
From: Peter Eisentraut
Date:
Subject: pgsql: pg_dump: Add missing newlines at end of messages
Next
From: Tom Lane
Date:
Subject: pgsql: Allow ON UPDATE/DELETE SET DEFAULT plans to be cached.