Re: Failover and vacuum

What additional information required?

On Sat, 29 Mar 2025, 08:55 Gurjeet Singh, <gurjeet(at)singh(dot)im> wrote:

> On Thu Mar 27, 2025 at 10:40 AM PDT, Raj wrote:
> > Hi
> >
> > Have 2 nodes ( primary and standby postgres 15.6) in openshift
> kubernetes.
> >
> > 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
>