On Mon, Mar 22, 2021 at 8:56 AM Luca Ferrari <fluca1...@gmail.com> wrote: > backend> select datname, age( datfrozenxid), current_setting( > 1: datname = "template0" (typeid = 19, len = 64, typmod > = -1, byval = f) > 2: age = "2138438218" (typeid = 23, len = 4, typmod = -1, byval = t) > 3: current_setting = "50000000" (typeid = 25, len = > -1, typmod = -1, byval = f) > ---- > 1: datname = "testdb" (typeid = 19, len = 64, typmod = -1, byval = > f) > 2: age = "2138438218" (typeid = 23, len = 4, typmod = -1, byval = t) > 3: current_setting = "50000000" (typeid = 25, len = > -1, typmod = -1, byval = f)
Another thing that comes into my mind as a doubt is: why are all databases becoming old? I mean, I'm provoking activity _only_ on testdb, therefore other database such as template1 are not doing anything. Why an emergency autovacuum is not freezing such databases before the wraparound happens? Luca
