Change pg_amop's index on (amopclaid,amopopr) to index (amopopr,amopclaid).
Tom Lane <tgl@sss.pgh.pa.us>
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.
Files
| Path | Change | +/− |
|---|---|---|
| src/backend/optimizer/path/indxpath.c | modified | +71 −80 |
| src/backend/utils/cache/lsyscache.c | modified | +3 −3 |
| src/backend/utils/cache/syscache.c | modified | +2 −2 |
| src/backend/utils/sort/tuplesort.c | modified | +15 −18 |
| src/include/catalog/catversion.h | modified | +2 −2 |
| src/include/catalog/indexing.h | modified | +3 −3 |