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 1sp6ig-00GcWm-Cb for pgsql-general@arkaria.postgresql.org; Fri, 13 Sep 2024 13:52:19 +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 1sp6if-003DII-G8 for pgsql-general@arkaria.postgresql.org; Fri, 13 Sep 2024 13:52:17 +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 1sp6if-003DI1-2O; Fri, 13 Sep 2024 13:52:17 +0000 Received: from mout.gmx.net ([212.227.17.22]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sp6ib-000zzl-9l; Fri, 13 Sep 2024 13:52:16 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmx.net; s=s31663417; t=1726235533; x=1726840333; i=karsten.hilbert@gmx.net; bh=AFY7p7uk/6EdiQ3X0nOtwYYdnMARaQlB+S30gVMcQmk=; h=X-UI-Sender-Class:Date:From:To:Subject:Message-ID:References: MIME-Version:Content-Type:In-Reply-To:Content-Transfer-Encoding: cc:content-transfer-encoding:content-type:date:from:message-id: mime-version:reply-to:subject:to; b=nctwELIjFPLYNmq6DqWJnw1pteJu6o+hn9UbMmTgGSZ0KXJBV/YnITg3qY4uCr7r 0hzo0PU5rvQJag/nVsVvyEeHgZ6AnkJvgww2SgIknRaLl3CEHeyRDeWaPP1+ZIUfv 3h2uVc1S7PJHtM1g4ZhjrUw02J+d2wIloKOnsMJw5iiSrzLXwzFE+qJDE+HorL7mv O8s+dkVUoP0uPo4sfUT3OUPOZfITACa7Dvn0+JBi4JZPTJTGtzPdvIjVchIA15bK3 Eou7pQMRVqmT88GpFJ2bd1VswAGWR0zbwCdM5ir6KhCaThFgl6Z5dsmRJ2yJPg0/p tFuU6XmQhS80ZxlwtQ== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from hermes ([84.144.218.143]) by mail.gmx.net (mrgmx105 [212.227.17.168]) with ESMTPSA (Nemesis) id 1N49hB-1rpt893Ycz-00uAPT; Fri, 13 Sep 2024 15:52:12 +0200 Received: from ncq by hermes with local (Exim 4.96) (envelope-from ) id 1sp6iZ-0004Ms-26; Fri, 13 Sep 2024 15:52:11 +0200 Date: Fri, 13 Sep 2024 15:52:11 +0200 From: Karsten Hilbert To: pgsql-general@lists.postgresql.org, pgsql-general@postgresql.org Subject: Re: Reg: Size difference Message-ID: Mail-Followup-To: pgsql-general@lists.postgresql.org, pgsql-general@postgresql.org References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: Ma_X_il-Followup-to: d Re_X_turn-receipt-to: Karsten.Hilbert@gmx.net Di_X_sposition-Notification-To: Karsten.Hilbert@gmx.net X-Confi_X_rm-Reading-To: Karsten.Hilbert@gmx.net X-Pri_X_ority: 2 (High) Sender: X-Provags-ID: V03:K1:cm0rcrjGFuKw8unJQdp58PyKroYHyzjjX/y1rOzTNXYLXzn+0iq g8RPuGkcusxHGrTHnUy4osYEtNAfBDJDt0xYCIXNq1lviqqPvMiCS+nZdIv/Ae5/eImciZ8 a8T48A0fip5W2tVgc8z4g4B/StIfUAnQXZ4PPaVw7FvBKIySGHH8F0pcSBPub2hBCWgjmtm kYjljcdRjEVNcr8fkYDTQ== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:CrYENHKdaio=;l05LlcLgJDzNqjF6tPWfZ9haHvV 1f4wFfk91YZc21SW83XhTHwxkIGTwzY7tIotGIS5lSPL5iXV7m/uVIk+qLOFNXzgabI/hIWwI DXkF2hJjytagiVZPhGMNRmRIkclJfFidGJda5T1/KRtfUwt30YLLC6nmIF8ilYK9TN5Pa63RZ lXqPrYbkqWTBhjq0Dp39Png66uNN3u7/TN7kPKbNnz2mkOeeARS12NzRlTpaujcmcLWuwAfme MEy6HsTQcapz4T3a+KRreYGgIQZZ0ADA0VJm6ImQDexRZU4PT2b6ZljJ9AX3EEhxzkbhCcJr6 MZN3yo3nJW+X+BfqRsSFTzQrO11Jt9AbARqLpuXueGco1jTMh7ieyPyGbP/SSYYBE8nXma8s5 UM3jtIOJ2XRi+cLgjBZsV6yOuU83Oc1akRwgC00drF2jobRtConiedUFSDm1a0RzhrDGz7Dtj Ne1ksyNG6Bx0WV7feuFhvQwt/ZapWLXRHIeghTDIi4mZGkTjGpT+yF9iIx/IRVzgRSVqsAXVE JOBHpUmKmXv3cvBSGF11TeCahILmtURg2/JcOXgggo2FWl9mRXPje5d07NRkHOxP1PK3a3RcC m1+l48BCSYwWSSrFHLB0M0mXQdmDP173cVQdRnnf0lfZPfdCjSjkV/3UcPGvFSRBUsVKXcMtM Swf6hCq5ZCD5gZjtg9p2w4VbnZBS1drfuS3HvtmWjdOw2Kvxxx6YaB/cWfnb4s+Qruh2W54J/ YqA7PavEwZGDGWIwog3WssmWGfA7zgnQVvRIOMvfBT7nDOI/ukzgR9jS3fK3vmud5cNz2l9vT O5HeNQHWmsRC1Ma5ooHCoCCA== Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Am Fri, Sep 13, 2024 at 05:39:22PM +0530 schrieb Vinay Oli: > 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 s= ync > with zero delay. First thing that comes to my mind is different effect of autovacuum between both clusters. Best, Karsten =2D- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B