Re: Need help to make space on my database - Mailing list pgsql-general

From Laurenz Albe
Subject Re: Need help to make space on my database
Date
Msg-id 083dcec070821812a08fec75d0a5c0bfd461ae21.camel@cybertec.at
Whole thread Raw
In response to Need help to make space on my database  ("Cocam' server" <cocamserver@gmail.com>)
List pgsql-general
On Mon, 2024-04-29 at 15:45 +0200, Cocam' server wrote:
> I need help to make space on my database. I have tables that are several GB in size.
> I used to use the VACUUM FULL VERBOSE command; but now, this command is too greedy in
> free space to be used and I'm looking for a way to make free space (given back to the OS)

If you don't have enough disk space for a VACUUM (FULL), your only option is
pg_dump / DROP DATABASE / CREATE DATABASE / restore.

Yours,
Laurenz Albe



pgsql-general by date:

Previous
From: "Cocam' server"
Date:
Subject: Re: Need help to make space on my database
Next
From: Adrian Klaver
Date:
Subject: Re: Need help to make space on my database