Unique indexes on system tables - Mailing list pgsql-hackers

From Bruce Momjian
Subject Unique indexes on system tables
Date
Msg-id 199911160437.XAA02308@candle.pha.pa.us
Whole thread Raw
In response to RE: [HACKERS] mdnblocks is an amazing time sink in huge relations  ("Hiroshi Inoue" <Inoue@tpf.co.jp>)
Responses RE: Unique indexes on system tables
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] Re: Postgresql Docs....
Next
From: "Hiroshi Inoue"
Date:
Subject: RE: Unique indexes on system tables