Unique indexes on system tables

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
Cc: PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Unique indexes on system tables
Date: 1999-11-16 04:37:56
Message-ID: 199911160437.XAA02308@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Hiroshi Inoue 1999-11-16 05:25:37 RE: Unique indexes on system tables
Previous Message Tom Lane 1999-11-16 04:00:55 Re: [HACKERS] Re: Postgresql Docs....