Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pTC4Z-00038J-R0 for pgsql-admin@arkaria.postgresql.org; Sat, 18 Feb 2023 01:31:31 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pTC4Y-0001us-9Z for pgsql-admin@arkaria.postgresql.org; Sat, 18 Feb 2023 01:31:30 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pTC4X-0001ui-Rn for pgsql-admin@lists.postgresql.org; Sat, 18 Feb 2023 01:31:29 +0000 Received: from mail-pg1-x52f.google.com ([2607:f8b0:4864:20::52f]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1pTC4R-0000m8-GC for pgsql-admin@lists.postgresql.org; Sat, 18 Feb 2023 01:31:28 +0000 Received: by mail-pg1-x52f.google.com with SMTP id e1so1602610pgu.6 for ; Fri, 17 Feb 2023 17:31:23 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=to:message-id:subject:date:mime-version:from :content-transfer-encoding:from:to:cc:subject:date:message-id :reply-to; bh=MtXO3jtK1NqWoPKXIKaNcC3qRJQ1/DhUI4DlJiUbEKU=; b=IsqU5BrjW93967ZqZXSvNlTJbaea1UsZAZR+DqV00tCEmIyHahaTEB3LuPIZDqpBCr v4tBaYtiIFEz3V6Irh0aAJQBa2e2pU0cykPlnwtQI/PseIF2f50zidhOWLtkMNX3htoc haIGsYqOZNuFw+cw87a+f2CoKnE+dWPWc9VLXpNibn3eAfHdayGuzX7SdNaki/YrZbrU 89FbDP1S0NRDtaFtlJ82CfCrxNNilY2FG2A3i5p26hTOodAWeRKzYh+7wZjvW7ahMq4T 3AP8vrdhkodAUb+pDTZBvNGnXjWDXmkx2xkRglr+D0A3fh6Nb71KUH4s/7EbFsHNpmwX LZ2A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=to:message-id:subject:date:mime-version:from :content-transfer-encoding:x-gm-message-state:from:to:cc:subject :date:message-id:reply-to; bh=MtXO3jtK1NqWoPKXIKaNcC3qRJQ1/DhUI4DlJiUbEKU=; b=VPouxLuF1ca/53hb9Z+/Z5QBCNASFsqLWSH+j6G2Sk3tngT2gZPrxsWxScYTi6SPFI KOQn++hFLOyMmKlUvkOXN5dD1PVy6az9rp9QQPBy1O40l/2WBqeWDQgJaZ1afEGL9hyG jkOVRQfoib84yslmcoTKIci+4fCq5zC3i0eLeCK/yPyv9s8NHE0W7OOJemyOiuicc2MM cAt/IOfwrkjL2IEJ6lh9bVfDrYMLn/46tZjJe+6IO9mLNgQUnqT1cQWjZu4HrUGemifw 7Fa+Ye0hb3EgUMGQNypuKyrzGxHajlnmMFzAofUSftwks1jq27P8Pg2QWJ0WEyPPhhmI e9Iw== X-Gm-Message-State: AO0yUKVqUI1/qA3VCXT8urS8otETsVZR+kw3L90h6V6DyRXm+q9eFPqt q5X8tFI9VBHa7cipzbnGuJ30cPCd7DI= X-Google-Smtp-Source: AK7set/eWVSlt0qit0GsNn+W89TLIWI7Cn4ZoxV3uEVkkFYQH4pORbntssIXdCZOO9EWHBVLXxzpLg== X-Received: by 2002:a62:84cd:0:b0:5a9:9ed0:158 with SMTP id k196-20020a6284cd000000b005a99ed00158mr7189014pfd.24.1676683881084; Fri, 17 Feb 2023 17:31:21 -0800 (PST) Received: from smtpclient.apple ([2607:fb91:20a:c0a3:a1e3:879e:5aeb:2b16]) by smtp.gmail.com with ESMTPSA id 11-20020aa7924b000000b005a8851e0cddsm3638940pfp.188.2023.02.17.17.31.20 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Fri, 17 Feb 2023 17:31:20 -0800 (PST) Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable From: Teja Jakkidi Mime-Version: 1.0 (1.0) Date: Fri, 17 Feb 2023 17:31:08 -0800 Subject: Vacuum and analyze for objects on physical stand by dbs Message-Id: To: pgsql-admin X-Mailer: iPhone Mail (20C65) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hello Admins, I have an environment with 1 primary and 2 physical stand by instances. We h= ave manually analyzed/ vacuumed tables on primary db recently. Later when we= checked analyze, vacuum on stand by dbs in pg_stat_user_tables it returns n= ull. Will vacuum/ analyze do not replicate to stand by instances?? Do we hav= e to run separately on all the Stand by instances?? Thanks, Teja. J.=