Re: Record last SELECT on a row? - Mailing list pgsql-general

From David G. Johnston
Subject Re: Record last SELECT on a row?
Date
Msg-id CAKFQuwbo1oHLXVYGS1pTpXpXxsmZSV63xgvmSvR-9HRRN-rgBQ@mail.gmail.com
Whole thread Raw
In response to Record last SELECT on a row?  (Matthias Leisi <matthias@leisi.net>)
List pgsql-general
On Wednesday, December 17, 2025, Matthias Leisi <matthias@leisi.net> wrote:
Any other ways this could be achieved?

Without the ability to modify the application which uses a direct database connection, you’d need to modify the server code or run some kind of proxy/man-in-the-middle server you can program.  I would avoid updating the table on write though - just keep a cache of sorts somewhere and periodically compare the cache to the live table.

David J.

pgsql-general by date:

Previous
From: Greg Sabino Mullane
Date:
Subject: Re: Record last SELECT on a row?
Next
From: "Colin 't Hart"
Date:
Subject: wal segment size