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)  ("Rob Richardson" <Rob.Richardson@rad-con.com>)
Re: How to free disk space  ("postgres Emanuel CALVO FRANCO" <postgres.arg@gmail.com>)
Re: How to free disk space  (Devrim GÜNDÜZ <devrim@gunduz.org>)
Re: How to free disk space  (Raymond O'Donnell <rod@iol.ie>)
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