Re: [PERFORM] Forcing WAL flush

2013-01-07 Thread Jeff Janes
On Mon, Jan 7, 2013 at 1:49 PM, james wrote: > Is there a way to force a WAL flush so that async commits (from other > connections) are flushed, short of actually updating a sacrificial row? > > Would be nice to do it without generating anything extra, even if it is > something that causes IO in t

Re: [PERFORM] Forcing WAL flush

2013-01-07 Thread james
Le 2013-01-07 à 16:49, james a écrit : Is there a way to force a WAL flush so that async commits (from other connections) are flushed, short of actually updating a sacrificial row? Would be nice to do it without generating anything extra, even if it is something that causes IO in the checkpoi

Re: [PERFORM] Forcing WAL flush

2013-01-07 Thread François Beausoleil
Le 2013-01-07 à 16:49, james a écrit : > Is there a way to force a WAL flush so that async commits (from other > connections) are flushed, short of actually updating a sacrificial row? > > Would be nice to do it without generating anything extra, even if it is > something that causes IO in the

[PERFORM] Forcing WAL flush

2013-01-07 Thread james
Is there a way to force a WAL flush so that async commits (from other connections) are flushed, short of actually updating a sacrificial row? Would be nice to do it without generating anything extra, even if it is something that causes IO in the checkpoint. Am I right to think that an empty t