RE: Temporary tables prevent autovacuum, leading to XID wraparound - Mailing list pgsql-hackers

From Tsunakawa, Takayuki
Subject RE: Temporary tables prevent autovacuum, leading to XID wraparound
Date
Msg-id 0A3221C70F24FB45833433255569204D1F8AD84F@G01JPEXMBYT05
Whole thread Raw
In response to Re: Temporary tables prevent autovacuum, leading to XID wraparound  (Masahiko Sawada <sawada.mshk@gmail.com>)
List pgsql-hackers
From: Masahiko Sawada [mailto:sawada.mshk@gmail.com]
> Thank you for suggestion. It sounds more smarter. So it would be more better
> if we vacuums database for anti-wraparound in ascending order of
> relfrozenxid?

I thought so, too.  The current behavior is inconsistent: the launcher tries to assign all workers to one database with
thebiggest wraparound risk in order to eliminate the risk as fast as possible, but the workers don't get hurry to
reducethe risk.
 

Regards
Takayuki Tsunakawa



pgsql-hackers by date:

Previous
From: Masahiko Sawada
Date:
Subject: Re: Temporary tables prevent autovacuum, leading to XID wraparound
Next
From: Amit Khandekar
Date:
Subject: Re: Query running for very long time (server hanged) with parallel append