From: | Michael Guerin <guerin(at)rentec(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | pg_attribute has way too many row versions |
Date: | 2004-08-17 19:35:32 |
Message-ID: | 41225E04.6060504@rentec.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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 would expect 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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2004-08-17 19:48:47 | Re: pg_attribute has way too many row versions |
Previous Message | operationsengineer1 | 2004-08-17 18:51:49 | PGSQL 7.4.3 Compatible with 7.4.2? |