OSDN Git Service

Change pg_amop's index on (amopclaid,amopopr) to index (amopopr,amopclaid).
authorTom Lane <tgl@sss.pgh.pa.us>
Tue, 13 May 2003 04:38:58 +0000 (04:38 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Tue, 13 May 2003 04:38:58 +0000 (04:38 +0000)
commit1c9ac7dfd032b3e75067cf9dad1e6731e2ae0078
tree5445325c66bf163bc4e556aa193192fb9ee9874a
parent30f609484d025bfb7c69f8f6b9610dc981cb5fb8
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/backend/optimizer/path/indxpath.c
src/backend/utils/cache/lsyscache.c
src/backend/utils/cache/syscache.c
src/backend/utils/sort/tuplesort.c
src/include/catalog/catversion.h
src/include/catalog/indexing.h