On Fri, Mar 28, 2025 at 11:25 PM Gurjeet Singh <gurjeet@singh.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?
