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  ("Hiroshi Inoue" <Inoue@tpf.co.jp>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] Re: Postgresql Docs....
Следующее
От: "Hiroshi Inoue"
Дата:
Сообщение: RE: Unique indexes on system tables