Re: Restarting standby database have to reaply WAL (redo logs)

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: Cesar Otero <cesar(dot)otero(dot)souto(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Restarting standby database have to reaply WAL (redo logs)
Date: 2007-09-25 18:28:55
Message-ID: 1190744935.4181.510.camel@ebony.site
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message scottb 2007-09-26 16:16:33 log_duration / log_min_duration_statement differences between 8.1.8 and 8.2.4
Previous Message Cesar Otero 2007-09-25 17:14:36 Re: Restarting standby database have to reaply WAL (redo logs)