Postgres Pro
Downloads
Home   >   mailing lists

What's the best practice to compare the transaction with the checkpoint? - Mailing list pgsql-novice

From Jialun Zhang
Subject What's the best practice to compare the transaction with the checkpoint?
Date
Msg-id CAMFL+Jg88HxVL75db9HY_QebL+iLGAH4p-0Drmii4z1m6QD7aw@mail.gmail.com
Whole thread Raw
Responses Re: What's the best practice to compare the transaction with the checkpoint?  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-novice
Tree view
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

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Why do we have checkPointCopy in ControlFileData?
Next
From: Laurenz Albe
Date:
Subject: Re: What's the best practice to compare the transaction with the checkpoint?