Re: Tracking last scan time - Mailing list pgsql-hackers

From Andres Freund
Subject Re: Tracking last scan time
Date
Msg-id 20221012195031.bqp4rkvua2kkh46k@awork3.anarazel.de
Whole thread Raw
In response to Re: Tracking last scan time  (Michael Paquier <michael@paquier.xyz>)
Responses Re: Tracking last scan time
List pgsql-hackers
Hi,

On 2022-10-12 15:40:21 +0900, Michael Paquier wrote:
> On Mon, Oct 03, 2022 at 12:55:40PM +0100, Dave Page wrote:
> > Thanks. It's just the changes in xact.c, so it doesn't seem like it would
> > cause you any more work either way, in which case, I'll leave it to you :-)
> 
> Okay, I have just moved the patch to the next CF then, still marked as
> ready for committer.  Are you planning to look at that?

Yep, doing so right now.

I think this should have at a basic test in src/test/regress/sql/stats.sql. If
I can write one in a few minutes I'll go for that, otherwise will reply
detailing difficulties.


> +      <para>
> +       The time of the last sequential scan of this table, based on the
> +       most recent transaction stop time
> +      </para></entry>

Related rows seem to say "on this table".

Greetings,

Andres Freund



pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: how to correctly react on exception in pfree function?
Next
From: Matthias van de Meent
Date:
Subject: Re: problems with making relfilenodes 56-bits