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

From Andrey Borodin
Subject Re: [HACKERS] On markers of changed data
Date
Msg-id 82661839-7346-46F3-9CCA-DF18C90453BF@yandex-team.ru
Whole thread Raw
In response to Re: [HACKERS] On markers of changed data  (Stephen Frost <sfrost@snowman.net>)
Responses Re: [HACKERS] On markers of changed data
Re: [HACKERS] On markers of changed data
List pgsql-hackers
Tom, Alvaro, Michael, and especially Septhen, thank you for your valuable comments.

I feel enlightened about mtime.
My takeaway is:
1. Any other marker would be better (It can be WAL scan during archiving, some new LSN-based mechanics* et c.)
2. mtime could be used, with precautions described by Stephen are taken.

But my other question still seems unanswered: can I use LSN logic for incrementing FSM and VM? Seems like most of the
timethere is valid LSN 


* I like the idea of using something for both incr(diff) backups and VACUUM, it worth thinking about.

Best regards, Andrey Borodin.



--
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: Tom Lane
Date:
Subject: Re: [HACKERS] Prepared statements assume text type in PG10
Next
From: Craig Ringer
Date:
Subject: Re: [HACKERS] Slow synchronous logical replication