After run VACUUM, you must run REINDEXDB to decrease indexes.
You can pg_resetxlog too, but you need restart server to do that.
2008/10/21 Ruben Blanco <rubenblan@gmail.com>:
> Hi:
>
> My database is growing fast taking too much disk space. How can I free disk
> space without performing a VACCUM FULL? It locks the database for several
> hours, and that is not a solution.
>
> I guess a backup-restore would do the work but, isn't there a better way to
> do this without shutting down postgres?
>
> Thanks in advandce.
>
>
--
Emanuel Calvo Franco
Syscope Postgresql DBA
BaPUG Member
