agora inbox for pgsql-admin@postgresql.org  

help / color / mirror / Atom feed

From: Gurjeet Singh <gurjeet@singh.im>
To: Raj <rajeshkumar.dba09@gmail.com>
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: Failover and vacuum
Date: Fri, 28 Mar 2025 20:25:08 -0700
Message-ID: <D8SFGIZBD6UW.2FQPOWHVZPM6K@singh.im> (raw)
In-Reply-To: <CAJk5AtabiLBH_ri_HUKjiafGVS+OJRaxEEXAXV5WRtJjs+F4pg@mail.gmail.com>
References: <CAJk5AtabiLBH_ri_HUKjiafGVS+OJRaxEEXAXV5WRtJjs+F4pg@mail.gmail.com>

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

view thread (7+ messages)  latest in thread

Message-ID: <D8SFGIZBD6UW.2FQPOWHVZPM6K@singh.im>
Permalink:  ../D8SFGIZBD6UW.2FQPOWHVZPM6K@singh.im/
Also on:    postgresql.org/message-id/D8SFGIZBD6UW.2FQPOWHVZPM6K@singh.im

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: gurjeet@singh.im, rajeshkumar.dba09@gmail.com, pgsql-admin@lists.postgresql.org
  Subject: Re: Failover and vacuum
  In-Reply-To: <D8SFGIZBD6UW.2FQPOWHVZPM6K@singh.im>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox