Re: DB size

From: luis(dot)roberto(at)siscobra(dot)com(dot)br
To: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
Cc: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: DB size
Date: 2021-04-26 20:59:10
Message-ID: 2121457965.3236462.1619470750583.JavaMail.zimbra@siscobra.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


----- 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?

Luis R. Weck

In response to

  • Re: DB size at 2021-04-26 20:45:34 from Alvaro Herrera

Responses

  • Re: DB size at 2021-04-27 06:57:32 from Guillaume Lelarge

Browse pgsql-general by date

  From Date Subject
Next Message Mike Beachy 2021-04-26 21:45:48 -1/0 virtualtransaction
Previous Message luis.roberto 2021-04-26 20:50:49 Re: DB size