> Running vacuumdb --full freed the rest of the disk space. Regarding indexes
> from what you said I understand that if I want to free the space used in the
> past by indexes and that isn't freed yet (but it should) I should run
> reindexdb (or reindex in SQL). I did that and another 300MB got freed so
> thank you for both hints,
Here is another link you might find useful.
http://linux.inet.hr/optimize_postgresql_database_size.html
I found it on this thread. It is an interesting read.
http://archives.postgresql.org/pgsql-general/2006-06/msg00632.php
Regards,
Richard Broersma Jr.
