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

Поиск
Список
Период
Сортировка
От Jialun Zhang
Тема Re: What's the best practice to compare the transaction with the checkpoint?
Дата
Msg-id CAMFL+JiRTm9Ymz+rkEVL9TOZXrwx9LPecBZeFGKy-BKTQ3T34g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: What's the best practice to compare the transaction with the checkpoint?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: What's the best practice to compare the transaction with the checkpoint?
Список 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

В списке pgsql-novice по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: What's the best practice to compare the transaction with the checkpoint?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: What's the best practice to compare the transaction with the checkpoint?