Re: Streaming a base backup from master - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: Streaming a base backup from master
Date
Msg-id 20100903152008.GS26232@tamriel.snowman.net
Whole thread Raw
In response to Re: Streaming a base backup from master  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: Streaming a base backup from master  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Re: Streaming a base backup from master  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Kevin,

* Kevin Grittner (Kevin.Grittner@wicourts.gov) wrote:
> While 1GB granularity would be OK, I doubt it's optimal; I think CRC
> checks for smaller chunks might be worthwhile.  My gut feel is that
> somewhere in the 64kB to 1MB range would probably be optimal for us,
> although the "sweet spot" will depend on how the database is used.
> A configurable or self-adjusting size would be cool.

We have something much better, called WAL.  If people want to keep their
backup current, they should use that after getting the base backup up
and working.  We don't need to support this for the base backup, imv.

In any case, it's certainly not something required for an initial
implementation..
Thanks,
    Stephen

pgsql-hackers by date:

Previous
From: Dave Page
Date:
Subject: Re: Windows Tools
Next
From: Thom Brown
Date:
Subject: Re: Streaming a base backup from master