Re: Failover and vacuum

On Fri, Mar 28, 2025 at 11:25 PM 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.
>

But don't vacuuming and analyze statistics get replicated?

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!