Re: Need help to make space on my database

Поиск
Список
Период
Сортировка
От Laurenz Albe
Тема Re: Need help to make space on my database
Дата
Msg-id 083dcec070821812a08fec75d0a5c0bfd461ae21.camel@cybertec.at
обсуждение исходный текст
Ответ на Need help to make space on my database  ("Cocam' server" <cocamserver@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: "Cocam' server"
Дата:
Сообщение: Re: Need help to make space on my database
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Need help to make space on my database