Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Tue, 25 Sep 2007 19:28:55 +0100
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
- References:
- Restarting standby database have to reaply WAL (redo logs)
- From: Cesar Otero
- Re: Restarting standby database have to reaply WAL (redo logs)
- From: Simon Riggs
- Re: Restarting standby database have to reaply WAL (redo logs)
- From: Cesar Otero
- Restarting standby database have to reaply WAL (redo logs)
- Prev by Date: Re: Restarting standby database have to reaply WAL (redo logs)
- Next by Date: log_duration / log_min_duration_statement differences between 8.1.8 and 8.2.4
- Previous by thread: Re: Restarting standby database have to reaply WAL (redo logs)
- Next by thread: log_duration / log_min_duration_statement differences between 8.1.8 and 8.2.4
- Indexes: