pg_attribute has way too many row versions

Поиск
Список
Период
Сортировка
От Michael Guerin
Тема pg_attribute has way too many row versions
Дата
Msg-id 41225E04.6060504@rentec.com
обсуждение исходный текст
Ответы Re: pg_attribute has way too many row versions  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-novice
pg_attribute has way too many row versions, how can I find out what's holding a reference to these row versions?  I
wouldexpect at most 4-5K row versions in this table. 

INFO:  vacuuming "pg_catalog.pg_attribute"
INFO:  index "pg_attribute_relid_attnam_index" now contains 15089905 row versions in 513390 pages
DETAIL:  724892 index row versions were removed.
29132 index pages have been deleted, 0 are currently reusable.
CPU 16.49s/8.57u sec elapsed 3799.71 sec.
INFO:  index "pg_attribute_relid_attnum_index" now contains 15112894 row versions in 131544 pages
DETAIL:  724892 index row versions were removed.
200 index pages have been deleted, 0 are currently reusable.
CPU 4.03s/5.94u sec elapsed 964.61 sec.
INFO:  "pg_attribute": removed 724892 row versions in 67005 pages
DETAIL:  CPU 2.52s/3.30u sec elapsed 4136.68 sec.
INFO:  "pg_attribute": found 724892 removable, 15000823 nonremovable row versions in 268172 pages

*DETAIL:  14998918 dead row versions cannot be removed yet.
*
There were 316065 unused item pointers.
0 pages are entirely empty.
CPU 27.13s/19.97u sec elapsed 9394.54 sec.
INFO:  analyzing "pg_catalog.pg_attribute"
INFO:  "pg_attribute": 268172 pages, 1877 rows sampled, 1877 estimated total rows


В списке pgsql-novice по дате отправления:

Предыдущее
От:
Дата:
Сообщение: PGSQL 7.4.3 Compatible with 7.4.2?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: pg_attribute has way too many row versions