>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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
