Why my vacuum fails?
От | Vilson farias |
---|---|
Тема | Why my vacuum fails? |
Дата | |
Msg-id | 002601c0ad90$64f75300$98a0a8c0@dti.digitro.com.br обсуждение исходный текст |
Ответы |
Re: Why my vacuum fails?
|
Список | pgsql-general |
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]$
В списке pgsql-general по дате отправления: