Quick Links

How to free disk space

From:	"Ruben Blanco" <rubenblan(at)gmail(dot)com>
To:	pgsql-general(at)postgresql(dot)org
Subject:	How to free disk space
Date:	2008-10-21 10:59:26
Message-ID:	9c6020900810210359o761b267ele0cf8c554b75920c@mail.gmail.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

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.

Responses

Varchar vs varchar(64) at 2008-10-21 12:07:31 from Rob Richardson
Re: How to free disk space at 2008-10-21 13:00:30 from postgres Emanuel CALVO FRANCO
Re: How to free disk space at 2008-10-21 13:23:44 from Devrim GÜNDÜZ
Re: How to free disk space at 2008-10-21 14:10:32 from Raymond O'Donnell

Browse pgsql-general by date

	From	Date	Subject
Next Message	Ivan Sergio Borgonovo	2008-10-21 11:20:12	exposing more parse was: Re: tsearch2: setting weights on tsquery
Previous Message	Ivan Sergio Borgonovo	2008-10-21 08:29:52	tsearch2: setting weights on tsquery