> -----Original Message-----
> From: Bruce Momjian [mailto:pgman@candle.pha.pa.us]
> Sent: Tuesday, November 16, 1999 1:38 PM
> To: Hiroshi Inoue
> Cc: PostgreSQL-development
> Subject: Unique indexes on system tables
>
>
> 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?
No.
It should be done to guarantee the uniqueness of system tuples.
> 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?
>
Yes.
> Second, I want to add more system indexes to match all caches. Anything
> that could cause problems there?
>
I am only afraid of index corruption.
The more we have system indexes,the more index corruption would happen.
How could we recover from the state ?
Tom suggested rebuilding indexes in vacuum.
According to Jan,there was a utility called reindexdb.
WAL by Vadim may be able to recover indexes completely in case of crash.
> Are you working on any of this?
>
No.
Regards.
Hiroshi Inoue
Inoue@tpf.co.jp