Search Postgresql Archives

Re: Bloated Table

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



>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

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux