MIME-Version: 1.0
References: <CACHNdrBT4MTTo_EGSHke+QxXwUUV40miraQwk4GR1wzsiogwnw@mail.gmail.com>
 <dbf507bc113a626d70f6e8088193f9a363688249.camel@cybertec.at>
In-Reply-To: <dbf507bc113a626d70f6e8088193f9a363688249.camel@cybertec.at>
From: Vinay Oli <olivinay541@gmail.com>
Date: Sat, 14 Sep 2024 23:41:14 +0530
Message-ID: <CACHNdrB7g41DYFedhhW+eWZCmEC3faSwu2Y9ZfKHuW4cTUd05g@mail.gmail.com>
Subject: Re: Reg: Size difference
To: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: pgsql-general@postgresql.org
Content-Type: multipart/alternative; boundary="000000000000a59f2606221844ef"
Archived-At: <https://www.postgresql.org/message-id/CACHNdrB7g41DYFedhhW%2BeWZCmEC3faSwu2Y9ZfKHuW4cTUd05g%40mail.gmail.com>
Precedence: bulk

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

Hi ,


I've verified there's no crap sitting. 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.


Thanks,
Vinay kumar

On Sat, Sep 14, 2024, 11:00=E2=80=AFPM Laurenz Albe <laurenz.albe@cybertec.=
at>
wrote:

> On Sat, 2024-09-14 at 22:49 +0530, Vinay Oli wrote:
> > 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.
>
> Try and identify if any of the database objects are different in size.
> That shouldn't happen.
>
> If all the database objects have the same size on both systems, the
> explanation is likely some unrelated crap sitting in the data directory
> on the standby.  Try to identify files that exist on one system, but
> not on the other.
>
> Yours,
> Laurenz Albe
>

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

<div dir=3D"auto"><span style=3D"font-size:12.8px">Hi ,</span><div dir=3D"a=
uto" style=3D"font-size:12.8px"><br></div><div dir=3D"auto" style=3D"font-s=
ize:12.8px"><br></div><div dir=3D"auto" style=3D"font-size:12.8px">I&#39;ve=
 verified there&#39;s no crap sitting. I&#39;ve checked the database size b=
y meta command \l+ and even I checked from file system level du -sh 49181 f=
older. 49181 is the db oid.</div><div dir=3D"auto" style=3D"font-size:12.8p=
x"><br></div><div dir=3D"auto" style=3D"font-size:12.8px"><br></div><div di=
r=3D"auto" style=3D"font-size:12.8px"><br></div><div dir=3D"auto" style=3D"=
font-size:12.8px">Thanks,</div><div dir=3D"auto" style=3D"font-size:12.8px"=
>Vinay kumar</div></div><br><div class=3D"gmail_quote"><div dir=3D"ltr" cla=
ss=3D"gmail_attr">On Sat, Sep 14, 2024, 11:00=E2=80=AFPM Laurenz Albe &lt;<=
a href=3D"mailto:laurenz.albe@cybertec.at">laurenz.albe@cybertec.at</a>&gt;=
 wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8=
ex;border-left:1px #ccc solid;padding-left:1ex">On Sat, 2024-09-14 at 22:49=
 +0530, Vinay Oli wrote:<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<b=
r>
&gt; is 104 GB, while the same database on the standby side is 216 GB.<br>
&gt; Both are in sync with zero delay.<br>
<br>
Try and identify if any of the database objects are different in size.<br>
That shouldn&#39;t happen.<br>
<br>
If all the database objects have the same size on both systems, the<br>
explanation is likely some unrelated crap sitting in the data directory<br>
on the standby.=C2=A0 Try to identify files that exist on one system, but<b=
r>
not on the other.<br>
<br>
Yours,<br>
Laurenz Albe<br>
</blockquote></div>

--000000000000a59f2606221844ef--