Re: DB size

Поиск
Список
Период
Сортировка
От Guillaume Lelarge
Тема Re: DB size
Дата
Msg-id CAECtzeU_+Ein2H+FUV41RbUZz5TC5_jR6Fm=U7sDGjoz+ZDiyg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: DB size  (luis.roberto@siscobra.com.br)
Список pgsql-general
Hi,

Le lun. 26 avr. 2021 à 22:59, <luis.roberto@siscobra.com.br> a écrit :

----- Mensagem original -----
> De: "Alvaro Herrera" <alvherre@alvh.no-ip.org>
> Para: "luis.roberto" <luis.roberto@siscobra.com.br>
> Cc: "pgsql-general" <pgsql-general@lists.postgresql.org>
> Enviadas: Segunda-feira, 26 de abril de 2021 17:45:34
> Assunto: Re: DB size

> I would guess that there are leftover files because of those crashes you
> mentioned. You can probably look for files in the database subdir in
> the data directory that do not appear in the pg_class.relfilenode
> listing for the database.

> --
> Álvaro Herrera 39°49'30"S 73°17'W
> <inflex> really, I see PHP as like a strange amalgamation of C, Perl, Shell
> <crab> inflex: you know that "amalgam" means "mixture with mercury",
> more or less, right?
> <crab> i.e., "deadly poison"


Thanks Alvaro!

That's what I read in an old thread, back in the 8.3 days... Can you point me in the right direction as to where sould I look and how do I know which files exactly are safe to remove?


pg_orphaned is probably what you need. See https://github.com/bdrouvot/pg_orphaned for details.


--
Guillaume.

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

Предыдущее
От: Laurenz Albe
Дата:
Сообщение: Re: -1/0 virtualtransaction
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: DB size