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 1spWaC-0026dG-5Q for pgsql-general@arkaria.postgresql.org; Sat, 14 Sep 2024 17:29:17 +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 1spWaB-000JkA-Pa for pgsql-general@arkaria.postgresql.org; Sat, 14 Sep 2024 17:29:15 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1spWaA-000JiJ-B9 for pgsql-general@lists.postgresql.org; Sat, 14 Sep 2024 17:29:15 +0000 Received: from fhigh7-smtp.messagingengine.com ([103.168.172.158]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1spWa5-001Bfe-Hl for pgsql-general@postgresql.org; Sat, 14 Sep 2024 17:29:13 +0000 Received: from phl-compute-04.internal (phl-compute-04.phl.internal [10.202.2.44]) by mailfhigh.phl.internal (Postfix) with ESMTP id 7F7B9114014C; Sat, 14 Sep 2024 13:29:08 -0400 (EDT) Received: from phl-mailfrontend-02 ([10.202.2.163]) by phl-compute-04.internal (MEProxy); Sat, 14 Sep 2024 13:29:08 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:content-transfer-encoding:content-type:content-type:date:date :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to; s=fm3; t=1726334948; x=1726421348; bh=He3VleqVInh4eqxgx+tVVs3yd7NHfp7QPjT3YaXMJxs=; b= QrGGQT3+HBxJ34ZXrWf7PeXMCGzoKs+QJwdVbFB59XYfJ52saacQqmkJOebyreZA d+UxZLe9fbrXzGB5GrWqwrs4+toVIG92wdXz0OM4lXqhyM/H4X4yAgp0Ho2Ni94G 5MR+XKJDDJErMpfVfTjDYA42VB6iqpvPs+LxmjgrOZt2Vg4Gm6yV9zGk7poLi1lz ZKc0ZU2mOB/5LEaCPl+RUgBKZ+KNpLQQuYXNRPmOj+rbEcJZLWw08KV15PaS+Zfe rgkBAX9RVdLaCvFJrd4vDn4GWXMgmPqvx/Jai9EZkmyxbwuF1lwI/G/Y1XYzi9uA IieMePj92FRAmjik9lwIOA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :content-type:date:date:feedback-id:feedback-id:from:from :in-reply-to:in-reply-to:message-id:mime-version:references :reply-to:subject:subject:to:to:x-me-proxy:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm1; t=1726334948; x= 1726421348; bh=He3VleqVInh4eqxgx+tVVs3yd7NHfp7QPjT3YaXMJxs=; b=A mBvFAvpvpP+Zu6ZaXDd80jyG2YRiXjs4rJ85x7OjFmCqJUjs8K9d9uI74K9CJjmC 5qDkSMUPBihIey5FxskUyTA1jNnRgU5si2vKanNfauFXlHN7cFXfs7icjl8W1sXq nzFJdg107xW3VXaE1ItnCNYWoKisde6BXQhWxkJBUgI5Rm/tOUD+epq46/wsCUnK 25SO3oDc/4pbzjZXZcml3v/lw27S1A3vL+F5OyKITW396Ql3aS3ydZ3IwlbRXYfp vumIzQiWMZvbNGmAJU7SLlFNjfhqCeuGL4+7UDn2VgbqvKy2YEF+C8sAIJHpKeup AB/adVlYAxJERYfLyDkrg== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeftddrudektddguddugecutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpggftfghnshhusghstghrihgsvgdp uffrtefokffrpgfnqfghnecuuegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivg hnthhsucdlqddutddtmdenucfjughrpefkffggfgfuvfhfhfgjtgfgsehtjeertddtvdej necuhfhrohhmpeetughrihgrnhcumfhlrghvvghruceorggurhhirghnrdhklhgrvhgvrh esrghklhgrvhgvrhdrtghomheqnecuggftrfgrthhtvghrnhepiedvhfeiheehgeeuieel jeeitedtjeehudegfeelkedvleekhedtgfeiffefkedunecuvehluhhsthgvrhfuihiivg eptdenucfrrghrrghmpehmrghilhhfrhhomheprggurhhirghnrdhklhgrvhgvrhesrghk lhgrvhgvrhdrtghomhdpnhgspghrtghpthhtohepvddpmhhouggvpehsmhhtphhouhhtpd hrtghpthhtohepohhlihhvihhnrgihheegudesghhmrghilhdrtghomhdprhgtphhtthho pehpghhsqhhlqdhgvghnvghrrghlsehpohhsthhgrhgvshhqlhdrohhrgh X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Sat, 14 Sep 2024 13:29:07 -0400 (EDT) Message-ID: <65a64890-17b9-45ec-8ac4-afb61794806c@aklaver.com> Date: Sat, 14 Sep 2024 10:29:06 -0700 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Reg: Size difference To: Vinay Oli , pgsql-general@postgresql.org References: Content-Language: en-US From: Adrian Klaver In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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 adrian.klaver@aklaver.com