Re: Streaming base backups

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: Hannu Krosing <hannu(at)2ndquadrant(dot)com>
Cc: Simon Riggs <simon(at)2ndquadrant(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Streaming base backups
Date: 2011-01-09 09:44:00
Message-ID: AANLkTim6bZQ_h=L4qLJkagB-boadHcJrpyq7wL1yM0EN@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sun, Jan 9, 2011 at 09:55, Hannu Krosing <hannu(at)2ndquadrant(dot)com> wrote:
> On 7.1.2011 15:45, Magnus Hagander wrote:
>>
>> On Fri, Jan 7, 2011 at 02:15, Simon Riggs<simon(at)2ndquadrant(dot)com>  wrote:
>>
>>> One very useful feature will be some way of confirming the number and
>>> size of files to transfer, so that the base backup client can find out
>>> the progress.
>>
>> The patch already does this. Or rather, as it's coded it does this
>> once per tablespace.
>>
>> It'll give you an approximation only of course, that can change,
>
> In this case you actually could send exact numbers, as you need to only
> transfer the files
>  up to the size they were when starting the base backup. The rest will be
> taken care of by
>  WAL replay

It will still be an estimate, because files can get smaller, and even
go away completely.

But we really don't need more than an estimate...

--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Hannu Krosing 2011-01-09 11:05:48 Re: Streaming base backups
Previous Message Jeff Davis 2011-01-09 09:03:10 Re: WIP: Range Types