Postgres Pro
Downloads
Home   >   mailing lists

Re: Restarting standby database have to reaply WAL (redo logs) - Mailing list pgsql-admin

From Simon Riggs
Subject Re: Restarting standby database have to reaply WAL (redo logs)
Date
Msg-id 1190744935.4181.510.camel@ebony.site
Whole thread Raw
In response to Re: Restarting standby database have to reaply WAL (redo logs)  ("Cesar Otero" <cesar.otero.souto@gmail.com>)
List pgsql-admin
Tree view 
On Tue, 2007-09-25 at 14:14 -0300, Cesar Otero wrote:

> I think that after restarting standby db the first log should be last
> log applied + 1

That isn't how it works, for performance reasons.

We don't make a restartpoint after each file, we do this on the first
usable checkpoint WAL record that we find after checkpoint_timeout
seconds.

--
  Simon Riggs
  2ndQuadrant  http://www.2ndQuadrant.com

pgsql-admin by date:

Previous
From: "Cesar Otero"
Date:
Subject: Re: Restarting standby database have to reaply WAL (redo logs)
Next
From: scottb@intercastingcorp.com
Date:
Subject: log_duration / log_min_duration_statement differences between 8.1.8 and 8.2.4