Re: How to free disk space - Mailing list pgsql-general

From Raymond O'Donnell
Subject Re: How to free disk space
Date
Msg-id 48FDE2D8.5030105@iol.ie
Whole thread Raw
In response to How to free disk space  ("Ruben Blanco" <rubenblan@gmail.com>)
List pgsql-general
On 21/10/2008 11:59, Ruben Blanco wrote:

> 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.

You shouldn't need to do VACUUM FULL - plain VACUUM should do the job.
Have a trawl through the archives, as this topic comes up regularly.

Ray.


------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

pgsql-general by date:

Previous
From: "Jozef Sevcik"
Date:
Subject: Re: Need Tool to sync databases with 8.3.1
Next
From: Simon Riggs
Date:
Subject: Re: [HACKERS] Hot Standby utility and administrator functions