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

From: Jialun Zhang <reatank(at)gmail(dot)com>
To: pgsql-novice(at)lists(dot)postgresql(dot)org
Subject: What's the best practice to compare the transaction with the checkpoint?
Date: 2020-07-04 16:19:15
Message-ID: CAMFL+Jg88HxVL75db9HY_QebL+iLGAH4p-0Drmii4z1m6QD7aw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi All,

I am trying to add code to determine whether the transaction is
checkpointed or not. So I think I need to compare the transaction ID with
the checkpoint's and determine whether it is older or not. Could anyone
tell me what's the best practice of doing this in Postgres? Is it done
somewhere in the existing code?

Thanks,
Jialun Zhang

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Laurenz Albe 2020-07-06 08:09:09 Re: What's the best practice to compare the transaction with the checkpoint?
Previous Message Tom Lane 2020-07-03 19:55:29 Re: Why do we have checkPointCopy in ControlFileData?