News for hackers. Stuff that matters.
Re:How Postgres Makes Transactions Atomic (2017) by petereisentraut on Wednesday September 18, 2019 @08:41AM (#21004705)
A snapshot is actually just a struct with a few transaction IDs (xids) and some other bookkeeping that describes which slice of the physically stored data is supposed to be visible to a transaction. The article shows the details of that. So the size of a snapshot is unrelated to the size of the database.
Re:How Postgres Makes Transactions Atomic (2017) by yvan on Wednesday September 18, 2019 @09:34AM (#21005226)
Thanks for the information. I read the article but didn't understand it well.