Re: Assigning fixed OIDs to system catalogs and indexes
От | Qingqing Zhou |
---|---|
Тема | Re: Assigning fixed OIDs to system catalogs and indexes |
Дата | |
Msg-id | d3htrr$o8k$1@news.hub.org обсуждение исходный текст |
Ответ на | Assigning fixed OIDs to system catalogs and indexes (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: Assigning fixed OIDs to system catalogs and indexes
|
Список | pgsql-hackers |
"Tom Lane" <tgl@sss.pgh.pa.us> writes > While thinking about the use of hand-assigned OIDs for pg_proc and > pg_operator, it occurred to me to wonder why we don't have hand-assigned > OIDs for all system catalogs and indexes. Currently, most of the time > that the C code wants to reference a specific catalog or index, it has > to reference it by name. If we had fixed OIDs for all the catalogs and > indexes known to the C code, we could get rid of heap_openr, > index_openr, and the index-by-name maintained inside the relcache, > because *all* such accesses would go by OID. I don't have hard numbers > to prove it, but I think that the aggregate overhead of doing string > instead of integer comparisons during those lookups has to be > nontrivial. There are other annoyances such as having to use > get_system_catalog_relid() in many places where a constant would be nice > to have. So some changing-oid operations like vacuum full, reindex, etc will not affect these system catalogs? Regards, Qingqing
В списке pgsql-hackers по дате отправления: