| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2010-04-27 15:31:05 | Re: Wierd quirk of HS/SR, probably not fixable |
| Previous Message | Heikki Linnakangas | 2010-04-27 15:13:59 | Re: Wierd quirk of HS/SR, probably not fixable |