On Mon, Feb 2, 2015 at 5:52 PM, Jim Nasby wrote:
> On 2/2/15 7:36 PM, Jim Nasby wrote:
>
>>
>>> Currently the fact that it needs to go back to old tables and FTS them
>>> every 2B transactions (or rely on autovacuum for this) and you can't do
>>> anything about it (like permanently freeze the tab
Hi,
I have to deal with badly written system which regularly suffers from
transaction wraparound issue. This issue is happenning every 10-14 days and
forces me to take system offline and vacuum in single-user mode.
Main causes for this are (afaik):
1) heavy transaction traffic + 100+GB of stale tab