From: | Luca Ferrari <fluca1978(at)gmail(dot)com> |
---|---|
To: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
Cc: | pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: questions about wraparound |
Date: | 2021-03-29 14:58:24 |
Message-ID: | CAKoxK+6oawL4JSCYPYSqa=YTb21qSydKBwjxZZZ3AEHjGeLugw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Mon, Mar 29, 2021 at 11:14 AM Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> wrote:
>
> If there is no activity on a database, its "datfrozenxid" stays
> the same. So, as transaction IDs are consumed, it is getting older
> automatically. That means that even inactive databases will receive
> an anti-wraparound vacuum occasionally. But that should not have
> to do anything except advance "datfrozenxid".
Thanks, but this is exactly my point: since inactive databases are
getting older, why it appears to me that autovacuum is not freezing
them? I mean, in my experiment age( datfrozenzid) reports the same age
for every database, even the inactive ones. And since there were
inactive databases, I was expecting emergency autovacuum to be able to
run and freeze them. Or am I wrong?
Luca
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2021-03-29 14:59:11 | Re: search_path in pg_dump output. |
Previous Message | Laurenz Albe | 2021-03-29 09:14:21 | Re: questions about wraparound |