Postgres Pro
Downloads
Home   >   mailing lists

How to free disk space - Mailing list pgsql-general

From Ruben Blanco
Subject How to free disk space
Date
Msg-id 9c6020900810210359o761b267ele0cf8c554b75920c@mail.gmail.com
Whole thread Raw
Responses Varchar vs varchar(64)
Re: How to free disk space
Re: How to free disk space
Re: How to free disk space
List pgsql-general
Tree view
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.

pgsql-general by date:

Previous
From: Ivan Sergio Borgonovo
Date:
Subject: tsearch2: setting weights on tsquery
Next
From: Ivan Sergio Borgonovo
Date:
Subject: exposing more parse was: Re: tsearch2: setting weights on tsquery