Tom Lane wrote:
Alvaro Herrera <[EMAIL PROTECTED]> writes:On Mon, Jan 24, 2005 at 06:57:54PM -0500, Tom Lane wrote:(Five minutes at least has a defensible rationale, ie it's the default checkpoint interval and we expect we can replay the log at least as fast as it was created initially.)
Hmm, I remember Mark Wong from OSDL saying that it took to replay the logs after a crash more than the six hours it had taken to generate them.
Six hours? Did he have checkpoints disabled somehow?
No, I remember they were talking about recovery from backup using PITR.
(i.e. not simple crash recovery, but replaying the logs from the whole benchmark session)
Best Regards,
Michael Paesold
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]