public inbox for [email protected]
help / color / mirror / Atom feedFrom: Laurenz Albe <[email protected]>
To: Jialun Zhang <[email protected]>
To: Tom Lane <[email protected]>
Cc: [email protected]
Subject: Re: What's the best practice to compare the transaction with the checkpoint?
Date: Tue, 07 Jul 2020 11:41:46 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAMFL+JhXVq45tOgNgWvhXU5s0SGUEcM7Oajuy488fZ4vh8CCtw@mail.gmail.com>
References: <CAMFL+Jg88HxVL75db9HY_QebL+iLGAH4p-0Drmii4z1m6QD7aw@mail.gmail.com>
<[email protected]>
<CAMFL+JjnQE8NWP1vMxfzJXFyjCP-9yvA6ku6FkJAjTpRkOoyTg@mail.gmail.com>
<[email protected]>
<CAMFL+JisTCugv5T8n=gQNFKcvWMMJwARz1sWwhv1nQ8=EKvQTQ@mail.gmail.com>
<[email protected]>
<CAMFL+JiRTm9Ymz+rkEVL9TOZXrwx9LPecBZeFGKy-BKTQ3T34g@mail.gmail.com>
<[email protected]>
<CAMFL+JhXVq45tOgNgWvhXU5s0SGUEcM7Oajuy488fZ4vh8CCtw@mail.gmail.com>
On Mon, 2020-07-06 at 17:50 -0400, Jialun Zhang wrote:
> > The replay of step 4 would need to perform something like "delete the file
> > for V if it exists, but don't complain if it does not", since we couldn't
> > be sure which state we'll find on-disk.
>
> What I am actually asking is that, is it possible that the replay depends
> on a deleted value, which has been physically removed by a VACUUM.
> Bear with my very basic knowledge in Postgres.
The WAL records that affect your out-of-line stored file would be written
by you, so you'd have to make sure that replaying such WAL records works
whether the file is present or not.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com
view thread (11+ messages)
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], [email protected]
Subject: Re: What's the best practice to compare the transaction with the checkpoint?
In-Reply-To: <[email protected]>
* 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