"Tom Lane" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
