public inbox for [email protected]
help / color / mirror / Atom feedFrom: Kashif Zeeshan <[email protected]>
To: Torsten Förtsch <[email protected]>
Cc: pgsql-general <[email protected]>
Subject: Re: Vacuum backend with backend_xmin?
Date: Tue, 11 Jun 2024 08:27:23 +0500
Message-ID: <CAAPsdhc+d6KMH_4PP4X1rn4Fqj_HsMWPOeMM9wh5xwrhdXzuFQ@mail.gmail.com> (raw)
In-Reply-To: <CAKkG4_mX+yO6oigW7YY6rXy0HTFj_bmrQ0_ktcxLKCxDbVaf4Q@mail.gmail.com>
References: <CAKkG4_mX+yO6oigW7YY6rXy0HTFj_bmrQ0_ktcxLKCxDbVaf4Q@mail.gmail.com>
Hi
On Mon, Jun 10, 2024 at 5:07 PM Torsten Förtsch <[email protected]>
wrote:
> Hi,
>
> This is a VACUUM FREEZE process.
>
> -[ RECORD 1 ]------+--------------
> pid | 129471
> datid | 16401
> datname | feed
> relid | 1889166
> phase | scanning heap
> heap_blks_total | 1254901
> heap_blks_scanned | 1017524
> heap_blks_vacuumed | 0
> index_vacuum_count | 0
> max_dead_tuples | 11184809
> num_dead_tuples | 0
> backend_xid | <NULL>
> backend_xmin | 3267908740
> age | 8572
>
> The query is:
>
> select v.*, a.backend_xid, a.backend_xmin, age(a.backend_xmin)
> from pg_stat_progress_vacuum as v join pg_stat_activity as a on a.pid=v.pid
>
> Now, my question is why does a vacuum backend have a backend_xmin? I am
> just curious.
>
it is the oldest transaction ID whose effects may not be
visible to the transaction running in the backend.
Since transaction IDs are stored in each row to determine its visibility,
the minimum of the "backend_xmin" of all backends determines the cut-off
point beyond which all backends will agree on the visibility of tuples.
This is for example relevant for VACUUM: it cannot remove any dead tuples
that contain a transaction ID that is not older than any backend's
Regards
Kashif Zeeshan
Bitnine Global
>
> Thanks,
> Torsten
>
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: Vacuum backend with backend_xmin?
In-Reply-To: <CAAPsdhc+d6KMH_4PP4X1rn4Fqj_HsMWPOeMM9wh5xwrhdXzuFQ@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox