On Fri, Dec 11, 2015 at 1:08 PM, Jeff Janes <jeff.ja...@gmail.com> wrote: > Since changes to datfrozenxid are WAL logged at the time they occur, > but the supposedly-synchronous change to ShmemVariableCache is not WAL > logged until the next checkpoint, a well timed crash can leave you in > the state where the system is in a tizzy about wraparound but each > database says "Nope, not me".
ShmemVariableCache is an in-memory data structure, so it's going to get blown away and rebuilt on a crash. But I guess it gets rebuild from the contents of the most recent checkpoint record, so that doesn't actually help. However, I wonder if it would be safe to for the autovacuum launcher to calculate an updated value and call SetTransactionIdLimit() to update ShmemVariableCache. But I'm somewhat confused what this has to do with Andres's report. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
