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...
In response to
pgsql-hackers by date
|Next:||From: Tom Lane||Date: 2010-04-27 15:31:05|
|Subject: Re: Wierd quirk of HS/SR, probably not fixable |
|Previous:||From: Heikki Linnakangas||Date: 2010-04-27 15:13:59|
|Subject: Re: Wierd quirk of HS/SR, probably not fixable|