public inbox for [email protected]  

help / color / mirror / Atom feed

From: Sushrut Shivaswamy <[email protected]>
To: Alexander Korotkov <[email protected]>
Cc: [email protected]
Subject: Re: Read data from Postgres table pages
Date: Tue, 19 Mar 2024 20:18:42 +0530
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAPpHfdstG2Eu6XwfwWLQUcTu+2vLxSJ_u9v0WWyJHzs57BOi2Q@mail.gmail.com>
References: <CAPpHfdstG2Eu6XwfwWLQUcTu+2vLxSJ_u9v0WWyJHzs57BOi2Q@mail.gmail.com>

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?

view thread (6+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Read data from Postgres table pages
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox