MIME-Version: 1.0
References: <CACHNdrBT4MTTo_EGSHke+QxXwUUV40miraQwk4GR1wzsiogwnw@mail.gmail.com>
 <65a64890-17b9-45ec-8ac4-afb61794806c@aklaver.com>
In-Reply-To: <65a64890-17b9-45ec-8ac4-afb61794806c@aklaver.com>
From: Vinay Oli <olivinay541@gmail.com>
Date: Sat, 14 Sep 2024 23:40:26 +0530
Message-ID: <CACHNdrBwHwjGsBKx=4C=mHqh-qYrg+uutsK=Np+O4DSqSJtADA@mail.gmail.com>
Subject: Re: Reg: Size difference
To: Adrian Klaver <adrian.klaver@aklaver.com>
Cc: pgsql-general@postgresql.org
Content-Type: multipart/alternative; boundary="000000000000bccc9c0622184156"
Archived-At: <https://www.postgresql.org/message-id/CACHNdrBwHwjGsBKx%3D4C%3DmHqh-qYrg%2BuutsK%3DNp%2BO4DSqSJtADA%40mail.gmail.com>
Precedence: bulk

--000000000000bccc9c0622184156
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hi

 I've checked the database size by meta command \l+ and even I checked from
file system level du -sh 49181 folder. 49181 is the db oid.

Pgwal directory is same 40gb at primary and standby servers.

All the directories are of same size,  49181 folder (oid)  is only having
different size.


Thanks,
Vinay kumar

On Sat, Sep 14, 2024, 10:59=E2=80=AFPM Adrian Klaver <adrian.klaver@aklaver=
.com>
wrote:

> On 9/14/24 10:19, Vinay Oli wrote:
> > Hi Team
> >
> > I have been using PostgreSQL for the past 6 years. PostgreSQL has
> > significantly impacted my life, providing me with great opportunities
> > for knowledge and self-development.
> >
> > I'm currently facing a strange issue with PostgreSQL 15.0. I have a
> > primary-standby setup that is in sync, with a replication slot in place=
.
> > There are 18 databases, and one of the databases on the primary side is
> > 104 GB, while the same database on the standby side is 216 GB. Both are
> > in sync with zero delay.
>
> How are you measuring the size?
>
> If you are measuring on the files system what is the size of the base/
> and pg_wal/ sub-directories in the %PG_DATA directoty?
>
> >
> > Could this be a bug? If so, has it been resolved in newer releases? If
> > it is not a bug, how can this issue be fixed? Is there a solution or an=
y
> > supporting documentation available?
> >
> > WAL and log files are being rotated properly. The issue is with a
> > database named services_mfs. On the primary cluster, the services_mfs
> > database is 104GB, but on the standby cluster, it is 216GB, even though
> > both cluster are in sync. The standby database is only used in case of =
a
> > crash, which is managed by a Patroni cluster with etcd.
> >
> >
> >
> > Thanks,
> >
> > Vinay Kumar
> >
> >
> >
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com
>
>

--000000000000bccc9c0622184156
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto">Hi=C2=A0<div dir=3D"auto"><br></div><div dir=3D"auto">=C2=
=A0I&#39;ve checked the database size by meta command \l+ and even I checke=
d from file system level du -sh 49181 folder. 49181 is the db oid.<br></div=
><div dir=3D"auto"><br></div><div dir=3D"auto">Pgwal directory is same 40gb=
 at primary and standby servers.=C2=A0</div><div dir=3D"auto"><br></div><di=
v dir=3D"auto">All the directories are of same size,=C2=A0 49181 folder (oi=
d)=C2=A0 is only having different size.=C2=A0</div><div dir=3D"auto"><br></=
div><div dir=3D"auto"><br></div><div dir=3D"auto"><br></div><div dir=3D"aut=
o">Thanks,=C2=A0</div><div dir=3D"auto">Vinay kumar</div></div><br><div cla=
ss=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Sat, Sep 14, 20=
24, 10:59=E2=80=AFPM Adrian Klaver &lt;<a href=3D"mailto:adrian.klaver@akla=
ver.com">adrian.klaver@aklaver.com</a>&gt; wrote:<br></div><blockquote clas=
s=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;pad=
ding-left:1ex">On 9/14/24 10:19, Vinay Oli wrote:<br>
&gt; Hi Team<br>
&gt; <br>
&gt; I have been using PostgreSQL for the past 6 years. PostgreSQL has <br>
&gt; significantly impacted my life, providing me with great opportunities =
<br>
&gt; for knowledge and self-development.<br>
&gt; <br>
&gt; I&#39;m currently facing a strange issue with PostgreSQL 15.0. I have =
a <br>
&gt; primary-standby setup that is in sync, with a replication slot in plac=
e. <br>
&gt; There are 18 databases, and one of the databases on the primary side i=
s <br>
&gt; 104 GB, while the same database on the standby side is 216 GB. Both ar=
e <br>
&gt; in sync with zero delay.<br>
<br>
How are you measuring the size?<br>
<br>
If you are measuring on the files system what is the size of the base/ <br>
and pg_wal/ sub-directories in the %PG_DATA directoty?<br>
<br>
&gt; <br>
&gt; Could this be a bug? If so, has it been resolved in newer releases? If=
 <br>
&gt; it is not a bug, how can this issue be fixed? Is there a solution or a=
ny <br>
&gt; supporting documentation available?<br>
&gt; <br>
&gt; WAL and log files are being rotated properly. The issue is with a <br>
&gt; database named services_mfs. On the primary cluster, the services_mfs =
<br>
&gt; database is 104GB, but on the standby cluster, it is 216GB, even thoug=
h <br>
&gt; both cluster are in sync. The standby database is only used in case of=
 a <br>
&gt; crash, which is managed by a Patroni cluster with etcd.<br>
&gt; <br>
&gt; <br>
&gt; <br>
&gt; Thanks,<br>
&gt; <br>
&gt; Vinay Kumar<br>
&gt; <br>
&gt; <br>
&gt; <br>
<br>
-- <br>
Adrian Klaver<br>
<a href=3D"mailto:adrian.klaver@aklaver.com" target=3D"_blank" rel=3D"noref=
errer">adrian.klaver@aklaver.com</a><br>
<br>
</blockquote></div>

--000000000000bccc9c0622184156--