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?