Unique indexes on system tables
От | Bruce Momjian |
---|---|
Тема | Unique indexes on system tables |
Дата | |
Msg-id | 199911160437.XAA02308@candle.pha.pa.us обсуждение исходный текст |
Ответ на | RE: [HACKERS] mdnblocks is an amazing time sink in huge relations ("Hiroshi Inoue" <Inoue@tpf.co.jp>) |
Ответы |
RE: Unique indexes on system tables
|
Список | pgsql-hackers |
Hiroshi, there are two things I want to do for 7.0. First, I want to make more of the system indexes unique. Are you aware of any reasons not to do that? I see you have done some of them already. I talked to Tom Lane, and he thinks that it will not cause problems because unique insertions/updates wait for transactions to commit before doing a conflicting change to the index, right? Second, I want to add more system indexes to match all caches. Anything that could cause problems there? Are you working on any of this? -- 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 по дате отправления: