System cache index cleanup
От | Bruce Momjian |
---|---|
Тема | System cache index cleanup |
Дата | |
Msg-id | 199911221759.MAA05297@candle.pha.pa.us обсуждение исходный текст |
Ответы |
Re: [HACKERS] System cache index cleanup
|
Список | pgsql-hackers |
I have made most system indexes unique. I have added indexes to match all system caches. I have renamed some cache names to be clearer. I have re-ordered the cache entries to be alphabetical. I have renamed the inheritance *rel columns to be *relid. I have added a large comment to syscache.c listing steps needed to install a new system index. I saw no speed improvement from my changes, but I can imagine cases where this would be a speedup. The only thing missing is that I can't seem to get pg_shadow to use an index from the cache. When I try it, initdb runs really slow, and the resulting installation is unusable. Any ideas anyone? You can see my commented-out code in indexing.c and syscache.c. My guess is that the strange way we issue pg_exec_query_dest() calls is the cause. I have no call to CatalogIndexInsert() for the pg_shadow because of this. Anyone want to rewrite user.c to use heap_insert() instead. initdb required. -- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610) 853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania19026
В списке pgsql-hackers по дате отправления: