Re: How to free disk space

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