Re: [HACKERS] On markers of changed data - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: [HACKERS] On markers of changed data
Date
Msg-id 20171006144417.qq3siijflogrwtep@alvherre.pgsql
Whole thread Raw
In response to Re: [HACKERS] On markers of changed data  (Michael Paquier <michael.paquier@gmail.com>)
Responses Re: [HACKERS] On markers of changed data
List pgsql-hackers
Michael Paquier wrote:

> The only sane method for Postgres is really to scan the
> page header LSNs, and of course you already know that.

I hope the idea is not to have to scan every single page in the
database, because that would be too slow.  It should be possible to
build this so that a single summary LSN is kept for a largish group of
pages, allowing large portions of the database to be skipped from even
being read if they are known not to contain any page newer than the
previous backup.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: [HACKERS] On markers of changed data
Next
From: Konstantin Knizhnik
Date:
Subject: Re: [HACKERS] Issue with logical replication: MyPgXact->xmin alreadyis valid