Re: Proposal: Incremental Backup - Mailing list pgsql-hackers

From Andres Freund
Subject Re: Proposal: Incremental Backup
Date
Msg-id 20140812143000.GA18223@awork2.anarazel.de
Whole thread Raw
In response to Re: Proposal: Incremental Backup  (Claudio Freire <klaussfreire@gmail.com>)
Responses Re: Proposal: Incremental Backup
List pgsql-hackers
On 2014-08-12 10:25:21 -0300, Claudio Freire wrote:
> On Tue, Aug 12, 2014 at 6:41 AM, Marco Nenciarini
> <marco.nenciarini@2ndquadrant.it> wrote:
> > To declared two files identical they must have same size,
> > same mtime and same *checksum*.
> 
> Still not safe. Checksum collisions do happen, especially in big data sets.

If you use an appropriate algorithm for appropriate amounts of data
that's not a relevant concern. You can easily do different checksums for
every 1GB segment of data. If you do it right the likelihood of
conflicts doing that is so low it doesn't matter at all.

Greetings,

Andres Freund

-- Andres Freund                       http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training &
Services



pgsql-hackers by date:

Previous
From: "MauMau"
Date:
Subject: Re: [RFC] Should smgrtruncate() avoid sending sinval message for temp relations
Next
From: Kevin Grittner
Date:
Subject: Re: delta relations in AFTER triggers