From: | "Oelkers, Phil" <phil(dot)oelkers(at)experian(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | get me off this list please |
Date: | 2000-10-26 15:13:56 |
Message-ID: | F5F5D222CD70D111886C00805FE69D21024483E2@schexch1 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
-----Original Message-----
From: Brook Milligan [mailto:brook(at)biology(dot)nmsu(dot)edu]
Sent: Tuesday, October 24, 2000 4:05 PM
To: pgsql-general(at)postgresql(dot)org
Subject: [GENERAL] index problems
I am getting the following messages when I VACUUM ANALYZE:
NOTICE: Index pg_attribute_relid_attnum_index: NUMBER OF INDEX' TUPLES
(3579) IS NOT THE SAME AS HEAP' (4517).
Recreate the index.
NOTICE: Index pg_attribute_relid_attnam_index: NUMBER OF INDEX' TUPLES
(3579) IS NOT THE SAME AS HEAP' (4517).
Recreate the index.
How do I recreate these indexes? Is this a symptom of greater
problems?
I notice in src/backend/local1_template1.bki.source the following lines:
declare unique index pg_attribute_relid_attnam_index on pg_attribute using
btree(attrelid oid_ops, attname name_ops)
declare unique index pg_attribute_relid_attnum_index on pg_attribute using
btree(attrelid oid_ops, attnum int2_ops)
I presume these must be related to what I need to do, but I'm not sure
how to make use of this information (or even if I'm right). Should I
translate these into CREATE UNIQUE INDEX ... statements?
Thanks for the help.
Cheers,
Brook
From | Date | Subject | |
---|---|---|---|
Next Message | Oelkers, Phil | 2000-10-26 15:14:19 | please take me off this list |
Previous Message | Oelkers, Phil | 2000-10-26 15:13:36 | please take me off the list again |