Kevin Grittner wrote: > >>> On Tue, Dec 18, 2007 at 12:55 PM, in message <3149.1198004157@xxxxxxxxxxxxx>, > Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > > "David F. Skoll" <dfs@xxxxxxxxxxxxxxxxxx> writes: > >> My question is this: If the master database is fairly busy, gets > >> VACUUMed once a day, etc. can we expect the warm standby server > >> to work correctly after days/weeks/months/years of log shipping, > >> or should we periodically take new base backups? > > > > I don't think the time period is at issue. Log-shipping should keep the > > slave a perfect replica of the master (if it doesn't, we have problems > > anyway). > > Except for hint bits. This becomes more of a post-recovery > performance issue as the base backup ages, since they are included > in base backups, but not in WAL files. But hint bits should be replicated on the next full-page-write anyhow, no? -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
