logoalt Hacker News

ignoreusernamestoday at 10:56 AM1 replyview on HN

If safe keeper exposes the changes to the tables somehow, a type2 scd is just a windowed lag over the primary key sorted by the timestamp


Replies

nikitatoday at 2:54 PM

Safekeepers keep a window of WAL in Postgres WAL format and doesn’t have an external API.

It streams WAL to pageservers and Postgres read replicas