Hello everybody.
I'm using a view (http://pgsql.tapoueh.org/site/html/news/20080131.bloat.html)
to display the bloat (unused disk space) of the tables in a PostgreSQL
database. Using this data I want to implement a database maintenance script
automatically exectuting a VACUUM FULL on these tabl
Hello everybody.
I'm using a view (http://pgsql.tapoueh.org/site/html/news/20080131.bloat.html)
to display the bloat (unused disk space) of the tables in a PostgreSQL
database. Using this data I want to implement a database maintenance script
automatically exectuting a VACUUM FULL on these tabl
>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.1
