Search Postgresql Archives

Re: questions about wraparound

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Mon, Mar 22, 2021 at 8:56 AM Luca Ferrari <fluca1978@xxxxxxxxx> 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





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux