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
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general