Re: What's the best practice to compare the transaction with the checkpoint?

From: Jialun Zhang <reatank(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-novice(at)lists(dot)postgresql(dot)org
Subject: Re: What's the best practice to compare the transaction with the checkpoint?
Date: 2020-07-06 16:23:31
Message-ID: CAMFL+JiRTm9Ymz+rkEVL9TOZXrwx9LPecBZeFGKy-BKTQ3T34g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Thanks for your detailed reply!

My question is that, consider such a situation (in the order of time):
1. toast create a file for a value V;
2. latest checkpoint;
3. use V (here the file is read);
4. delete the file when VACUUM deletes V;
5. crash, then when we recover from the latest checkpoint, the file will be
accessed again but it has gone.

Is my understanding correct? Is this situation possible? Actually this
question is my reason to think about the checkpointing things.

Best,
Jialun Zhang

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2020-07-06 16:34:48 Re: What's the best practice to compare the transaction with the checkpoint?
Previous Message Tom Lane 2020-07-06 15:44:35 Re: What's the best practice to compare the transaction with the checkpoint?