Re: DB size

Hi,

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

>
> ----- Mensagem original -----
> > De: "Alvaro Herrera" <alvherre(at)alvh(dot)no-ip(dot)org>
> > Para: "luis.roberto" <luis(dot)roberto(at)siscobra(dot)com(dot)br>
> > Cc: "pgsql-general" <pgsql-general(at)lists(dot)postgresql(dot)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.