Re: DB size

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, luis(dot)roberto(at)siscobra(dot)com(dot)br
Cc: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: DB size
Date: 2021-04-27 06:58:46
Message-ID: 8fa46955e1516d15230fc59559db3eb7b8d066cd.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, 2021-04-26 at 16:45 -0400, Alvaro Herrera wrote:
> 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.

Not all tables have their "relfilenode" set:

SELECT relfilenode FROM pg_class WHERE relname = 'pg_class';
relfilenode
═════════════
0
(1 row)

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com

In response to

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

Responses

  • Re: DB size at 2021-04-27 07:05:42 from Magnus Hagander

Browse pgsql-general by date

  From Date Subject
Next Message Magnus Hagander 2021-04-27 07:05:42 Re: DB size
Previous Message Guillaume Lelarge 2021-04-27 06:57:32 Re: DB size