Re: [Junk released by User action] Re: [Junk released by User action]Re: [External] Postgres Database Disk Usage

Поиск
Список
Период
Сортировка
От Guillaume Lelarge
Тема Re: [Junk released by User action] Re: [Junk released by User action]Re: [External] Postgres Database Disk Usage
Дата
Msg-id CAECtzeW6ryoE+wotzx1EqL4RXgE6y-_nGd3M0HBWmnbDSv37oA@mail.gmail.com
обсуждение исходный текст
Ответ на Postgres Database Disk Usage  (Jeremiah Bauer <jbauer@agristats.com>)
Список pgsql-admin
Дерево обсуждения

Le lun. 11 févr. 2019 à 08:44, CONVERS Yann - DREAL Auvergne-Rhône-Alpes/CIDDAE/SIG <yann.convers@developpement-durable.gouv.fr> a écrit :
Hi,

vaccum full don't deliver free space from  files not in database. Your files are in the same directory but postgres doesn't kows them.

You must restore database and rename it, if you need to keep same name.

you can delete files without link in pg_database but it's more dangerous if you make mistake.

I have doing that to time last month on database of 300 GB.

I think i have a bog between proxmox/postgres 9.6.11 and ubuntu 16.04 but i haven't found it


There's more chance that PostgreSQL crashed for whatever reason and it lost tracks of some files because of that. Did you experience crash with PostgreSQL? because it shouldn't forget files otherwise.


--
Guillaume.

В списке pgsql-admin по дате отправления:

Предыдущее
От: Rohit Arora
Дата:
Сообщение: Re: ERROR: out of memory
Следующее
От: Jorge Torralba
Дата:
Сообщение: Calculating mem requirements for parallel queries and Docker and coredumps!