Skip site navigation (1) Skip section navigation (2)

Re: Differential backup

From: Csaba Nagy <ncslists(at)googlemail(dot)com>
To: Merlin Moncure <mmoncure(at)gmail(dot)com>
Cc: Michael Tharp <gxti(at)partiallystapled(dot)com>, Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, Simon Riggs <simon(at)2ndquadrant(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Differential backup
Date: 2010-04-27 15:28:54
Message-ID: 1272382134.7500.11.camel@pcd12478 (view raw or flat)
Thread:
Lists: pgsql-hackers
Hi all,

On Tue, 2010-04-27 at 11:07 -0400, Merlin Moncure wrote:
> The block level case seems pretty much covered by the hot standby feature.

One use case we would have is to dump only the changes from the last
backup of a single table. This table takes 30% of the DB disk space, it
is in the order of ~400GB, and it's only inserted, never updated, then
after ~1 year the old entries are archived. There's ~10M new entries
daily in this table. If the backup would be smart enough to only read
the changed blocks (in this case only for newly inserted records), it
would be a fairly big win...

Cheers,
Csaba.



In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2010-04-27 15:31:05
Subject: Re: Wierd quirk of HS/SR, probably not fixable
Previous:From: Heikki LinnakangasDate: 2010-04-27 15:13:59
Subject: Re: Wierd quirk of HS/SR, probably not fixable

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group