public inbox for [email protected]  

help / color / mirror / Atom feed

From: Adrian Klaver <[email protected]>
To: Vinay Oli <[email protected]>
To: [email protected]
Subject: Re: Reg: Size difference
Date: Sat, 14 Sep 2024 10:29:06 -0700
Message-ID: <[email protected]> (raw)
In-Reply-To: <CACHNdrBT4MTTo_EGSHke+QxXwUUV40miraQwk4GR1wzsiogwnw@mail.gmail.com>
References: <CACHNdrBT4MTTo_EGSHke+QxXwUUV40miraQwk4GR1wzsiogwnw@mail.gmail.com>

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 any 
> 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
[email protected]

view thread (2+ messages)  latest in thread

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