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

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Jialun Zhang <reatank(at)gmail(dot)com>, 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 08:09:09
Message-ID: 0bf46f63bd9f7e57a83710644a0ed4cf5f6c52f0.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Sat, 2020-07-04 at 12:19 -0400, Jialun Zhang wrote:
> 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?

You could use

SELECT next_xid FROM pg_control_checkpoint();

to get information about the last checkpoint.

I refrain from asking what the point of the exercise is...

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Jialun Zhang 2020-07-06 14:09:35 Re: What's the best practice to compare the transaction with the checkpoint?
Previous Message Jialun Zhang 2020-07-04 16:19:15 What's the best practice to compare the transaction with the checkpoint?