public inbox for [email protected]  

help / color / mirror / Atom feed

From: Laurenz Albe <[email protected]>
To: Vinay Oli <[email protected]>
To: [email protected]
Subject: Re: Reg: Size difference
Date: Sat, 14 Sep 2024 19:30:37 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <CACHNdrBT4MTTo_EGSHke+QxXwUUV40miraQwk4GR1wzsiogwnw@mail.gmail.com>
References: <CACHNdrBT4MTTo_EGSHke+QxXwUUV40miraQwk4GR1wzsiogwnw@mail.gmail.com>

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

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Reg: Size difference
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox