Sender: Gurjeet Singh <singh.gurjeet@gmail.com>
Mime-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain; charset=UTF-8
Date: Fri, 28 Mar 2025 20:25:08 -0700
Message-Id: <D8SFGIZBD6UW.2FQPOWHVZPM6K@singh.im>
Subject: Re: Failover and vacuum
From: "Gurjeet Singh" <gurjeet@singh.im>
To: "Raj" <rajeshkumar.dba09@gmail.com>, "Pgsql-admin"
 <pgsql-admin@lists.postgresql.org>
References: 
 <CAJk5AtabiLBH_ri_HUKjiafGVS+OJRaxEEXAXV5WRtJjs+F4pg@mail.gmail.com>
In-Reply-To: 
 <CAJk5AtabiLBH_ri_HUKjiafGVS+OJRaxEEXAXV5WRtJjs+F4pg@mail.gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/D8SFGIZBD6UW.2FQPOWHVZPM6K%40singh.im>
Precedence: bulk

On Thu Mar 27, 2025 at 10:40 AM PDT, Raj wrote:
> Hi
>
> Have 2 nodes ( primary and standby postgres 15.6)  in openshift kubernete=
s.
>
> Patroni setup. 300gb data. No failover since last six months. Suddenly
> after failover, there were lot of issues such as too many connections and
> slowness.
>
> Is it due to not analyze done in new node?

There isn't enough information in your message for anyone to take an
educated guess. If you see evidence of vacuum not being performed on
certain tables for a while, yes that may explain queries taking too
long, which may cause other symptoms. If analyze hasn't been performed
for a while, then you may see suboptimal plans for the queries.

But, again, you haven't provided enough information, so you may not get
very helpful answers.

Best regards,
Gurjeet
http://Gurje.et