On Wed, Oct 14, 2009 at 12:12 PM, Joseph S <[email protected]> wrote: > Well obviously, but my question is why the big pauses after some > "remoteHelperThread_1_1: allocate line buffers" but not all of them?
Turn on logging and see what's going on. I notice slowness sometimes. The best I've been able to ascertain is that the FETCH on the origin is taking a long time, or that the COMMIT on the replica is taking a long time. I'm betting that's due to the fsync() on the WAL file. It is such a fast moving target that it is very hard to detect exactly what is making it slow. It happens to my application as well, not just slony, so I don't think it is a slony specific issue. _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
