Re: Forcing wal rotation

On Sun, 2006-07-16 at 01:04 +0300, Hannu Krosing wrote:
> Ühel kenal päeval, R, 2006-07-14 kell 17:39, kirjutas Simon Riggs:
> > On Fri, 2006-07-14 at 12:09 -0400, Tom Lane wrote:
> > > "Florian G. Pflug" <fgp(at)phlo(dot)org> writes:
> > > > I've now thought about how to fix that without doing that rather
> crude rsync-pg_xlog-hack.
> > > > I've read through the code, and learned that wal-segments are
> expected to have a specific size -
> > > > thus rotating them "early" is not that easy.
> > >
> > > Simon was working on a patch for this at the code sprint; I think
> it's
> > > submitted to -patches already.
> >
> > Slightly different patch. I'm working on this one still.
>
> What is your approach here ?

I'm just posting a prototype patch to -patches now that implements
pg_switch_xlog().

This is to allow some further discussion as people have requested; I've
got 3 working days between now and code freeze and these are allocated
to work in this area. That isn't a last minute thing, just that my
schedule has been too full mid-month with customer-related work.

--
Simon Riggs
EnterpriseDB http://www.enterprisedb.com