If we query the DB directly, is it possible to know which new rows have been added since the last query? Is there a change pump that can be latched onto?
I’m assuming the page data structs are encapsulated in specific headers which can be used to list / read pages. Why would Postgres need to be stopped to read the data? The read / query path in Postgres would also be reading these pages when the instance is running?
