From: | "Subbiah, Stalin" <SSubbiah(at)netopia(dot)com> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | Vacuum Verbose output |
Date: | 2005-10-31 20:13:27 |
Message-ID: | 6B26A56846293C4488B54CF3E440335403E2F77A@mxca2.corp.netopia.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi All,
We vacuum busy tables in different frequencies depending on how busy the
table is. Today I noticed that one of the task that was suppose to
delete rows from a busy table was running for a long time. And below is
the output of vacuum verbose after the task was stopped from running.
Trying to understand if the table/index has been bloated or not.
INFO: vacuuming "public.eventlog"
INFO: index "ix_eventlog_eventtime" now contains 11465395 row versions
in 77113 pages
DETAIL: 8737797 index row versions were removed.
Does it mean ix_eventlog_ index had 11.4mil row versions out of which
8.7mil were removed cause of deletes?
33189 index pages have been deleted, 0 are currently reusable.
Does it mean out of 77113 index pages, 33189 were deleted?
CPU 5.24s/13.76u sec elapsed 67.05 sec.
INFO: "eventlog": removed 8737797 row versions in 361856 pages
DETAIL: CPU 14.53s/22.00u sec elapsed 122.13 sec.
INFO: index "ix_eventlog_eventtime" now contains 8023399 row versions
in 77116 pages
DETAIL: 3442698 index row versions were removed.
46439 index pages have been deleted, 0 are currently reusable.
CPU 3.18s/5.35u sec elapsed 22.85 sec.
INFO: "eventlog": removed 3442698 row versions in 143144 pages
DETAIL: CPU 5.64s/8.74u sec elapsed 69.15 sec.
INFO: "eventlog": found 12180495 removable, 8022620 nonremovable row
versions in 837938 pages
DETAIL: 0 dead row versions cannot be removed yet.
There were 154716 unused item pointers.
0 pages are entirely empty.
CPU 44.37s/54.07u sec elapsed 357.04 sec.
Why does index and table INFO reported twice with different row version
numbers on a vacuum run.
Thanks,
Subbiah
Postgres v7.4.7
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-10-31 21:22:59 | Re: Vacuum Verbose output |
Previous Message | Ng Pheng Siong | 2005-10-31 18:02:34 | filesystem permissions and security |