Re: Bloated Table

From: Alexander Schöcke <asc(at)turtle-entertainment(dot)de>
To: "Bill Moran" <wmoran(at)potentialtech(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Bloated Table
Date: 2009-05-27 16:09:44
Message-ID: 4F1490B538ECAC4BA98D23915717B82D0105150E@winexch1.office.turtle-entertainment.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>What is the output of VACUUM VERBOSE foobar_log?

INFO: vacuuming "public.foobar_log"
INFO: index "bar_index" now contains 23832007 row versions in 118151 pages
DETAIL: 0 index row versions were removed.
0 index pages have been deleted, 0 are currently reusable.
CPU 0.02s/0.00u sec elapsed 64.10 sec.
INFO: index "foobarid_foobar_log_key" now contains 23832007 row versions in 65347 pages
DETAIL: 0 index row versions were removed.
0 index pages have been deleted, 0 are currently reusable.
CPU 0.02s/0.00u sec elapsed 32.60 sec.
INFO: index "foo_foobar_log_key" now contains 23832007 row versions in 65347 pages
DETAIL: 0 index row versions were removed.
0 index pages have been deleted, 0 are currently reusable.
CPU 0.03s/0.00u sec elapsed 25.14 sec.
INFO: "foobar_log": found 0 removable, 23832007 nonremovable row versions in 269835 pages
DETAIL: 0 dead row versions cannot be removed yet.
There were 0 unused item pointers.
1 pages contain useful free space.
0 pages are entirely empty.
CPU 0.16s/0.09u sec elapsed 299.55 sec.
VACUUM

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Grzegorz Jaśkiewicz 2009-05-27 16:15:07 \dt+ on 8.4
Previous Message Joshua Tolley 2009-05-27 15:29:51 Re: Postgres registry access using java