On Wed, Apr 10, 2019 at 09:42:47PM +0200, Peter Eisentraut wrote: > That is a great analysis. Seems like block-level is the preferred way > forward.
In any solution related to incremental backups I have see from community, all of them tend to prefer block-level backups per the filtering which is possible based on the LSN of the page header. The holes in the middle of the page are also easier to handle so as an incremental page size is reduced in the actual backup. My preference tends toward a block-level approach if we were to do something in this area, though I fear that performance will be bad if we begin to scan all the relation files to fetch a set of blocks since a past LSN. Hence we need some kind of LSN map so as it is possible to skip a one block or a group of blocks (say one LSN every 8/16 blocks for example) at once for a given relation if the relation is mostly read-only. -- Michael
signature.asc
Description: PGP signature
