Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ukWY7-003W0F-SH for pgsql-admin@arkaria.postgresql.org; Fri, 08 Aug 2025 23:31:00 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1ukWY6-00HX19-B6 for pgsql-admin@arkaria.postgresql.org; Fri, 08 Aug 2025 23:30:58 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ukWY5-00HX0x-S4 for pgsql-admin@lists.postgresql.org; Fri, 08 Aug 2025 23:30:57 +0000 Received: from mail-oi1-x229.google.com ([2607:f8b0:4864:20::229]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1ukWY3-001TNG-0I for pgsql-admin@postgresql.org; Fri, 08 Aug 2025 23:30:56 +0000 Received: by mail-oi1-x229.google.com with SMTP id 5614622812f47-433f1f97199so1702806b6e.1 for ; Fri, 08 Aug 2025 16:30:55 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1754695855; x=1755300655; darn=postgresql.org; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :from:to:cc:subject:date:message-id:reply-to; bh=5HAqr+MxeJK0X2C5iFpRRMLU+7K+OB7NIzU+ced25QI=; b=IbtxoxxqWr8pik1pj1lzJCPwLgrvky/u9gm/FhZ1fgc2mBb/yIfQyOhAjrzz2+mTRg dvXhPQYzR1uAdgFCFQTS8r/X/Tq8j12Bf+eg9LTSrUo3BV/xGlZNWKk2lIFqu+1CK7J+ c+PrZTuVS+vSM6JJz46A55Zca+lYN0GsdeowFqeeOaiBjp25FDUVBGFnIztscUs74wMG t6Vad+InnuodOEwBVkGXSP46+9JIidHmYrjFbdKJBa6yXp6opY+8QNkFxv5AFGlQ6YG3 C/lqkzjEGc13Y7qoxPgul8zt02r/K7J3+BcdIHB6tDeDo4vIuKY350JSKxKXGIJknG9D bUgA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1754695855; x=1755300655; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=5HAqr+MxeJK0X2C5iFpRRMLU+7K+OB7NIzU+ced25QI=; b=NmBa5M0BsCKelB0bLB4sGpxFCTD+M2VwvYk/FyvIns6OF/hUNkGkZpNHvPfiCyt4UJ KnNNnNRTmBCSmCBibQccDRnQgzR2uepxbt0/zsz1FNogIaCZQM2enYwl7eZzALj2CtaW L72qvFvXw/w+eneOUx+V9iR+9LznS0/3dSmNObwuKcZlQ2o75v9Ze60XSUtFsbK++4Ce nJ0FU3bqCr/7xdO1R82B8GxdvWBL79K0BbC2TYULedjS/aqjPlJWE/sfWmp+A15JN65/ wStmK4XBNEZdCxKDMTJqpG3lyY/wC0R8E+XuLq00+6WRyMAsSs4VAJw3+rOPFvOYxNNO g8BQ== X-Gm-Message-State: AOJu0YxigJCvUWLhyVj6mWY+z3fL/1o0h5n9oZ39pWbi+TxaJn8gVS+T iVrvptonzzhVDC4Ztlr/0saXXwgOubJTId2AyFyK0NApeRtfgp2/7rrO1GaQmzOo5SF2xQLHkZ+ sVw5dL5QKMFvE61KluxsVc3bniI4hCpXtow== X-Gm-Gg: ASbGncttMjk6ECVMLIlTfSvFQLBGS1D6MpYTNR5RWBbM5Uqxx/SghQxAnMQ8ddCxFeH P5aFyv5GRbFrAw4yG8iY9KSq4+FfqKYPIrpznkqpcyaR8XZ5TesgurqVdCZySPlkRzIRIgEqW0Q PyqEIoAF8eYH37TGeqVtIvwuvkpSwG/abzzbWwzqquyAI0zVlvfVxaZLUXLKSQegjHKi4RLU3m3 FjVTBcH X-Google-Smtp-Source: AGHT+IFtCuh/TuawGYS/XNeRtSqmOBHieOeyr4JsSYM2/CJc6VMZ2IGV5MUi5zdYypdQley/0QkDdNSKhhb5OnGQvUk= X-Received: by 2002:a05:6808:d51:b0:424:b3f9:c865 with SMTP id 5614622812f47-43597d33fedmr2810412b6e.18.1754695855068; Fri, 08 Aug 2025 16:30:55 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Ron Johnson Date: Fri, 8 Aug 2025 19:30:44 -0400 X-Gm-Features: Ac12FXzK9UJpkUp9AXLhZ1ET7H2XvVo3fab2KiGeKTxe051RFBHTwx_-AFcPMVk Message-ID: Subject: Re: DB size value different than "/data" dir size To: "pgsql-admin@postgresql.org" Content-Type: multipart/alternative; boundary="000000000000215b03063be2f70e" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000215b03063be2f70e Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Fri, Aug 8, 2025 at 7:17=E2=80=AFPM Ghiurea, Isabella < Isabella.Ghiurea@nrc-cnrc.gc.ca> wrote: > Hi List, > > I am running PGSQL version 12.3 > Ignoring the fact that PG 12 is nine months EOL, 12.3 is missing a _lot_ of bug fixes. You should be on 12.22. > cfg master-slave with streaming replication and I am facing a issue > in the present active Pg db. > > The database size reported from the following : pg_size_pretty() or > pg_database_size() or sum all of db objects is grater than the sum siz= e > of all directories/files reported under > /var/lib/pgsql/data1/tbl_space_name/PG_12,,,xxx/ . ( db data tablespace) > > > [ Mention in standby PG db the size matches the /data sum file size and > also matches with the size reported in Pg active for pg_size_pretty() o= r > pg_database_size ] > > > What can be the issue? > What's in $PGDATA? --=20 Death to , and butter sauce. Don't boil me, I'm still alive. lobster! --000000000000215b03063be2f70e Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Fri, Aug 8, 2025 at 7:17=E2=80=AFPM Gh= iurea, Isabella <Isab= ella.Ghiurea@nrc-cnrc.gc.ca> wrote:

Hi List,

I am running=C2=A0 =C2=A0PGSQL version 12.3=C2=A0

<= /blockquote>

Ignoring the=C2=A0fact that PG 12 is nine m= onths EOL, 12.3 is missing a=C2=A0_lot_ of bug=C2=A0fixes.=C2=A0 You should= be on 12.22.
=C2=A0

=C2= =A0cfg=C2=A0=C2=A0=C2=A0master-slave=C2=A0 with=C2=A0 streaming replication= and I am facing a issue in the present active Pg db.=C2=A0

The database size reported from=C2=A0 the following :=C2=A0pg_size_prett= y() or pg_database_size() or sum all of db=C2=A0 objects is=C2=A0 grater th= an the=C2=A0 sum size of=C2=A0 all=C2=A0directories/files reported=C2=A0 un= der /var/lib/pgsql/data1/tbl_space_name/PG_12,,,xxx/ .=C2=A0 ( db data tabl= espace)


[=C2=A0Mention in standby PG db the size matches the /data=C2=A0 sum fil= e size and also=C2=A0 matches=C2=A0with the size reported in Pg active for= =C2=A0 pg_size_pretty() or pg_database_size ]


What can be the issue?


=
What's in $PGDATA?

--
=
Death to <Redacted>, and butter sauce.
Don't= boil me, I'm still alive.
<Redacted> lobster!
=
--000000000000215b03063be2f70e--