From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | pgsql-hackers(at)postgreSQL(dot)org |
Subject: | Catalog index cleanup blitz planned |
Date: | 2001-06-11 17:22:20 |
Message-ID: | 5366.992280140@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
I am planning to deal with all of the following TODO items today:
* pg_database should have unique indexes on oid and on datname.
* pg_shadow should have unique indexes on usename and on usesysid.
* pg_am should have unique index on oid
* pg_opclass should have unique index on oid
* pg_amproc should have unique index on amid+amopclaid+amprocnum
* Remove pg_rewrite's unnecessary index on oid, delete unused RULEOID
syscache.
* Remove index on pg_listener for performance reasons.
* Change pg_attrdef's nonunique index on adrelid into a unique index
on adrelid+adnum.
Have I missed anything in this line?
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | The Hermit Hacker | 2001-06-11 17:30:20 | RE: Baby girl |
Previous Message | mlw | 2001-06-11 17:21:14 | OID Wrap |