pgsql-server/src backend/optimizer/path/indxpa ...
pgsql-server/src backend/optimizer/path/indxpa ...
От:
tgl@postgresql.org (Tom Lane)
Дата:
CVSROOT: /cvsroot Module name: pgsql-server Changes by: tgl@postgresql.org 03/05/13 00:38:58 Modified files: src/backend/optimizer/path: indxpath.c src/backend/utils/cache: lsyscache.c syscache.c src/backend/utils/sort: tuplesort.c src/include/catalog: catversion.h indexing.h Log message: 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.