I don't remember where I read it, but I saw something online a while back
comparing vacuum stragies vs dumping with pg_dump and then reloading. The
pg_dump and restore ended up compacting the database significantly more. I
don't know if that still applies with 8.2, but it might be worth a try. I
c
On fös, 2006-12-29 at 07:09 -0800, Mario Behring wrote:
> Anyway, the openNMS database is very large now, more than 25GB
> (considering all tables) and I am starting to have disk space issues.
> The openNMS product has a vacuumdb procedure that runs every 24 hours
> and reads a vacuumd-configurati
Hi list,
I have an openNMS server that uses a Postgres database. For those who are not
familiar, openNMS is an open source network management product.
Anyway, the openNMS database is very large now, more than 25GB (considering all
tables) and I am starting to have disk space issues. The openNMS