Mario Splivalo wrote:
> On Wed, 2006-06-21 at 21:30 -0400, Bruce Momjian wrote:
> > Mario Splivalo wrote:
> > > Can I force archiving of the WAL files using CHECKPOINT statement? My
> > > checkpoing_segments is set to 32, but still archive_command is beeing
> > > called up only every 45 minutes or so. Is there a way to speed this up a
> > > bit? (I'd love to have it around 10 minutes, so I can have almost-live
> > > backed-up server).
> > No, but it is on the TODO list.
> So, the only thing I could to is to reduce checkpoint_segments?
No, that doesn't help because a partially-filled WAL file with little
database activity could be stay unarchived for a long time.
Bruce Momjian bruce(at)momjian(dot)us
+ If your life is a hard drive, Christ can be your backup. +
In response to
pgsql-admin by date
|Next:||From: kah_hang_ang||Date: 2006-06-23 05:51:22|
|Subject: Is it possible to trace all transactions done?|
|Previous:||From: Jeff Frost||Date: 2006-06-23 02:51:49|
|Subject: Re: strange fsm issues|