Re: Failover and vacuum

From: "Gurjeet Singh" <gurjeet(at)singh(dot)im>
To: "Raj" <rajeshkumar(dot)dba09(at)gmail(dot)com>, "Pgsql-admin" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Failover and vacuum
Date: 2025-03-29 03:25:08
Message-ID: D8SFGIZBD6UW.2FQPOWHVZPM6K@singh.im
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Raj 2025-03-29 06:39:33 Re: Failover and vacuum
Previous Message Ron Johnson 2025-03-27 21:45:12 Re: Permisson Required