Greetings,
I'm trying to do a vacuum and it's not working very well. Could you
please tell me what can I do?
The main problems appears to be related with "Cannot insert a duplicate
key into unique index pg_attribute_relid_attnum_index" message. How can I
fix it?
Thanks a lot.
[postgres@dgtao postgres]$ /usr/bin/vacuumdb --analyze --verbose -d bxs >
/home/postgres/log4.txt 2>&1
[postgres@dgtao postgres]$ cat log4.txt
NOTICE: --Relation pg_type--
NOTICE: Pages 4: Changed 0, reaped 1, Empty 0, New 0; Tup 230: Vac 0,
Keep/VTL 0/0, Crash 0, UnUsed 51, MinLen 105, MaxLen 109; Re-using:
Free/Avail. Space 6124/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.02u sec.
NOTICE: Index pg_type_typname_index: Pages 7; Tuples 212: Deleted 0. CPU
0.00s/0.00u sec.
NOTICE: Index pg_type_typname_index: NUMBER OF INDEX' TUPLES (212) IS NOT
THE SAME AS HEAP' (230).
Recreate the index.
NOTICE: Index pg_type_oid_index: Pages 2; Tuples 234: Deleted 0. CPU
0.00s/0.00u sec.
NOTICE: Index pg_type_oid_index: NUMBER OF INDEX' TUPLES (234) IS NOT THE
SAME AS HEAP' (230).
Recreate the index.
NOTICE: --Relation pg_attribute--
NOTICE: Pages 57: Changed 1, reaped 39, Empty 3, New 0; Tup 1845: Vac 210,
Keep/VTL 0/0, Crash 29, UnUsed 1848, MinLen 98, MaxLen 100; Re
-using: Free/Avail. Space 251548/241720; EndEmpty/Avail. Pages 1/37. CPU
0.00s/0.14u sec.
NOTICE: Index pg_attribute_relid_attnum_index: Pages 24; Tuples 1506:
Deleted 0. CPU 0.00s/0.02u sec.
NOTICE: Index pg_attribute_relid_attnum_index: NUMBER OF INDEX' TUPLES
(1506) IS NOT THE SAME AS HEAP' (1845).
Recreate the index.
NOTICE: Index pg_attribute_relid_attnam_index: Pages 56; Tuples 1506:
Deleted 0. CPU 0.00s/0.03u sec.
NOTICE: Index pg_attribute_relid_attnam_index: NUMBER OF INDEX' TUPLES
(1506) IS NOT THE SAME AS HEAP' (1845).
Recreate the index.
ERROR: Cannot insert a duplicate key into unique index
pg_attribute_relid_attnum_index
vacuumdb: vacuum failed
[postgres@dgtao postgres]$
