If I see a sudden connection spike (say once in 2 months). What are the
steps I need to follow as a dba?
Check idle and kill? Check of stat activity for active queries? How do I
ensure how much time is long running query? Blocking queries? How much of
blocking time is considered to be dangerous? L
i should do to avoid this issue in the future ?
On Mon, 9 Dec 2019, 20:05 Robert Haas, wrote:
> On Mon, Dec 9, 2019 at 4:52 AM rajesh kumar
> wrote:
> > We recently started seeing an error “ERROR: uncommitted xmin 347341220
> from before xid cutoff 967029200 needs to be froz
Hi All,
We recently started seeing an error “ERROR: uncommitted xmin 347341220
from before xid cutoff 967029200 needs to be frozen” on our user tables.
I’m unable to do ‘vacuum’, ‘vacuum freeze’ or ‘vacuum full’ on the
affected tables.
>From what I read, this was a bug couple of years ago on Sy
