Re: [PERFORM] why pg_class.relfrozenxid needs to be updated for frozen tables (where all rows have xmin=2)?

2015-02-02 Thread Slava Mudry
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

[PERFORM] why pg_class.relfrozenxid needs to be updated for frozen tables (where all rows have xmin=2)?

2015-01-30 Thread Slava Mudry
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