From 1c9ac7dfd032b3e75067cf9dad1e6731e2ae0078 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Tue, 13 May 2003 04:38:58 +0000 Subject: Change pg_amop's index on (amopclaid,amopopr) to index (amopopr,amopclaid). This makes no difference for existing uses, but allows SelectSortFunction() and pred_test_simple_clause() to use indexscans instead of seqscans to locate entries for a particular operator in pg_amop. Better yet, they can use the SearchSysCacheList() API to cache the search results. --- src/include/catalog/catversion.h | 4 ++-- src/include/catalog/indexing.h | 6 +++--- 2 files changed, 5 insertions(+), 5 deletions(-) (limited to 'src/include') diff --git a/src/include/catalog/catversion.h b/src/include/catalog/catversion.h index c96df3034f1..4a538376ecc 100644 --- a/src/include/catalog/catversion.h +++ b/src/include/catalog/catversion.h @@ -37,7 +37,7 @@ * Portions Copyright (c) 1996-2002, PostgreSQL Global Development Group * Portions Copyright (c) 1994, Regents of the University of California * - * $Id: catversion.h,v 1.191 2003/05/12 23:08:50 tgl Exp $ + * $Id: catversion.h,v 1.192 2003/05/13 04:38:58 tgl Exp $ * *------------------------------------------------------------------------- */ @@ -53,6 +53,6 @@ */ /* yyyymmddN */ -#define CATALOG_VERSION_NO 200305121 +#define CATALOG_VERSION_NO 200305122 #endif diff --git a/src/include/catalog/indexing.h b/src/include/catalog/indexing.h index 4a76a27dec6..ea251a329ce 100644 --- a/src/include/catalog/indexing.h +++ b/src/include/catalog/indexing.h @@ -8,7 +8,7 @@ * Portions Copyright (c) 1996-2002, PostgreSQL Global Development Group * Portions Copyright (c) 1994, Regents of the University of California * - * $Id: indexing.h,v 1.77 2002/11/15 02:50:10 momjian Exp $ + * $Id: indexing.h,v 1.78 2003/05/13 04:38:58 tgl Exp $ * *------------------------------------------------------------------------- */ @@ -23,7 +23,7 @@ * References to specific system indexes in the C code should use these * macros rather than hardwiring the actual index name. */ -#define AccessMethodOperatorIndex "pg_amop_opc_opr_index" +#define AccessMethodOperatorIndex "pg_amop_opr_opc_index" #define AccessMethodStrategyIndex "pg_amop_opc_strategy_index" #define AccessMethodProcedureIndex "pg_amproc_opc_procnum_index" #define AggregateFnoidIndex "pg_aggregate_fnoid_index" @@ -115,7 +115,7 @@ extern void CatalogUpdateIndexes(Relation heapRel, HeapTuple heapTuple); DECLARE_UNIQUE_INDEX(pg_aggregate_fnoid_index on pg_aggregate using btree(aggfnoid oid_ops)); DECLARE_UNIQUE_INDEX(pg_am_name_index on pg_am using btree(amname name_ops)); DECLARE_UNIQUE_INDEX(pg_am_oid_index on pg_am using btree(oid oid_ops)); -DECLARE_UNIQUE_INDEX(pg_amop_opc_opr_index on pg_amop using btree(amopclaid oid_ops, amopopr oid_ops)); +DECLARE_UNIQUE_INDEX(pg_amop_opr_opc_index on pg_amop using btree(amopopr oid_ops, amopclaid oid_ops)); DECLARE_UNIQUE_INDEX(pg_amop_opc_strategy_index on pg_amop using btree(amopclaid oid_ops, amopstrategy int2_ops)); DECLARE_UNIQUE_INDEX(pg_amproc_opc_procnum_index on pg_amproc using btree(amopclaid oid_ops, amprocnum int2_ops)); DECLARE_UNIQUE_INDEX(pg_attrdef_adrelid_adnum_index on pg_attrdef using btree(adrelid oid_ops, adnum int2_ops)); -- cgit v1.2.3