Re: Bloated Table - Mailing list pgsql-general

From Alexander Schöcke
Subject Re: Bloated Table
Date
Msg-id 4F1490B538ECAC4BA98D23915717B82D0105150E@winexch1.office.turtle-entertainment.de
Whole thread Raw
In response to Re: Bloated Table  (Bill Moran <wmoran@potentialtech.com>)
List 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

pgsql-general by date:

Previous
From: Joshua Tolley
Date:
Subject: Re: Postgres registry access using java
Next
From: Grzegorz Jaśkiewicz
Date:
Subject: \dt+ on 8.4