On 2018-05-24 17:13:11 -0400, Alvaro Herrera wrote: > On 2018-May-24, Andres Freund wrote: > > > On 2018-05-24 16:49:40 -0400, Alvaro Herrera wrote: > > > BTW is it just a coincidence or are all the affected tables pg_authid? > > > Maybe the problem is shared relations ..? Maybe the fact that they have > > > separate relfrozenxid (!?) in different databases? > > > > Yes, that appears to be part of the problem. I've looked at a number of > > shared relation related codepaths, but so far my theory is that the > > relcache is wrong. Note that one of the reports in this thread clearly > > had a different relcache relfrozenxid than in the catalog. > > Hmm ... is that because they read the values on different databases? > Are you referring to the reports by Maxim Boguk? I see one value from > template1, another value from template0. I was referring to https://www.postgresql.org/message-id/20180522193007.4bi5oluqb7c72oq2@xxxxxxxxxxxxxxxxx but you're right, it's possible that that's just caused by time passing or different databases. Greetings, Andres Freund
