Re: AW: how long should Archive logs be retained

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: "Subramanian,Ramachandran" <ramachandran(dot)subramanian(at)alte-leipziger(dot)de>, "pgsql-novice(at)lists(dot)postgresql(dot)org" <pgsql-novice(at)lists(dot)postgresql(dot)org>
Subject: Re: AW: how long should Archive logs be retained
Date: 2025-11-28 07:15:31
Message-ID: 4172b7bc435b7d5dd3205500514f6871be80448b.camel@cybertec.at
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Fri, 2025-11-28 at 05:28 +0000, Subramanian,Ramachandran wrote:
> Each transaction has it's own private copy of the data it is interested in,
> and each private copy of the data has it's unique transaction number associated
> with it.

A snapshot is not a copy of the data. It is the list of transaction IDs that
are visible and the ones that are not. That snapshot determines which of the
data in the database you can see.

Yours,
Laurenz Albe

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Chris Papademetrious 2025-12-27 12:36:20 is there a way to automate deduplication of strings?
Previous Message Laurenz Albe 2025-11-28 07:10:49 Re: AW: how long should Archive logs be retained