On 11-11-09 01:19 PM, Mike Wilson wrote: > Seeing "fetch 500 from LOG" almost continuously in my PG logs for a new Slony > 2.0.7 install. The previous version (2.0.3?) didn't show these messages in > the PG log. Researching the issue, historically, this message was usually > accompanied by a performance issue. This isn't the case with my databases > though, they appear to be running just as well as ever and the lag between > replicated nodes appears to be about the same as the previous version. > > I guess my question is what does this message mean in this version of Slony? > Is it an indication of sub-optimal slon parameters? > slon -g 20 $SLON_CLUSTER "host=$HOSTNAME port=$PORT dbname=$DB user=$USER" > > And how can I get rid of it if it's not an issue? > > Mike
What is causing the 'fetch 500' statements to show up in the server log? Are you only logging SQL that takes longer than x milliseconds? If so how long are your fetch 500 statements taking? How many rows are in your sl_log_1 and sl_log_2? > > > > > > _______________________________________________ > Slony1-general mailing list > [email protected] > http://lists.slony.info/mailman/listinfo/slony1-general _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
