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 1spWbb-0026oG-Le for pgsql-general@arkaria.postgresql.org; Sat, 14 Sep 2024 17:30:44 +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 1spWbb-000OEY-5l for pgsql-general@arkaria.postgresql.org; Sat, 14 Sep 2024 17:30:43 +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 1spWba-000OEO-RK for pgsql-general@lists.postgresql.org; Sat, 14 Sep 2024 17:30:42 +0000 Received: from mail-ej1-x635.google.com ([2a00:1450:4864:20::635]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1spWbX-001BgN-Ar for pgsql-general@postgresql.org; Sat, 14 Sep 2024 17:30:42 +0000 Received: by mail-ej1-x635.google.com with SMTP id a640c23a62f3a-a8d0d82e76aso490015966b.3 for ; Sat, 14 Sep 2024 10:30:40 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20230601.gappssmtp.com; s=20230601; t=1726335039; x=1726939839; darn=postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=9ZCjgohQhZiZpjvihIbE2jJ/2bA+9XsYH1I9dAZRtfE=; b=Mpu61kRdUZ9OluQcc/kyZ6YvHmMCe4a7eVmC6rmbJX5ZX9BgG6EwEXZDg0B8hjeLTO f5Et8LJIvKwgdvzxR89DbHhz7uEcywNEtc7hjQY+ydx5Bs+Q5hxBY52P9tUWekqtX3s3 3t0PVxn2Oio2W79q2vROtiVdCcpZ1ZuyyPL+cmGoF8bf+auzfofDjn9+I2mkRPG9Z9ru rGAzO9UCAom0jlwMj2JDeKlAtl9qKVjq+BMIqKQAZDv983IWosMYzx0dHNAJd6ZxpNO/ ZeoVzt+HaeClCgfWjfOGX8mDiyfY6QJF/cvUcQKy5gJVVFMDG1feou2cuwhYUJEETrhc hh8g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1726335039; x=1726939839; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=9ZCjgohQhZiZpjvihIbE2jJ/2bA+9XsYH1I9dAZRtfE=; b=w8KZLQCU0HTqBjktYBZbxgtaZjM2C1/T69xRCFCHyK0AJP9LZuRNMD6xRzFCHTeKQY jB1kCsVN3bb+sDEdPI49ujQIfdswz/RO/ZJ7+7dVxWPvig83kwme7KdAkwfn/B9WTqWc 8P14rVOOc0b6QwTtDxaaIs2YWvT2LfsdMk84NQMLbjLXYiEco8AS6O1yhwtBOGNam5dl qzyr3Gvm8kvxqxZEYFQTMzh99YukTiq9LN5RdrIWnO6UmDBenmy7cPXqR6DRBfbMbnW2 SnWNCU8vtOcGsifGfQWQgQOYQEIl+wQZvM6OyX6pxSBKyDtSu7+UMrN7C22Q8E1QlbCm KAEg== X-Forwarded-Encrypted: i=1; AJvYcCVNqhzxpGlGYVxgsoWQ+EVuvfFljsK0zBs//SXxS0SSNOMMh5D72uVpwWUC9GubMP6VIibsTF9MH7yF8OaO@postgresql.org X-Gm-Message-State: AOJu0Yz+y6tuy35M6TZCCv+22BR9brgUdV1qPk/gUfvz+F+iPmQRcKd+ BCvi2EvRoObhQzIAlwAzKr7cpFioMVUDnlrVjECjjoUuz7vDLPCRTlndAhLCndtIWV+mPxOqK/y Q X-Google-Smtp-Source: AGHT+IG1usNbxVMWfhnfK0U+VhHKbFLS79PYNLbMiFU2WwKE3uBsogUtB5qFnrbDeS8Fz3BYG3B/VA== X-Received: by 2002:a17:907:e6cb:b0:a90:126f:bcb6 with SMTP id a640c23a62f3a-a90293c5152mr987911066b.12.1726335038556; Sat, 14 Sep 2024 10:30:38 -0700 (PDT) Received: from dynamic-pd01.res.v6.highway.a1.net ([2001:871:260:35ac:ea40:e2b4:803a:2aad]) by smtp.gmail.com with ESMTPSA id a640c23a62f3a-a90612e5696sm103637666b.172.2024.09.14.10.30.38 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Sat, 14 Sep 2024 10:30:38 -0700 (PDT) Message-ID: Subject: Re: Reg: Size difference From: Laurenz Albe To: Vinay Oli , pgsql-general@postgresql.org Date: Sat, 14 Sep 2024 19:30:37 +0200 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.52.4 (3.52.4-1.fc40) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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