On 01/06/14 13:51, Brian Fehrle wrote: > ... > > 2014-01-06 11:43:22 MST DEBUG1 remoteHelperThread_1_1: 112.859 seconds > delay for first row > 2014-01-06 11:43:22 MST DEBUG1 remoteHelperThread_1_1: 112.906 seconds > until close cursor > 2014-01-06 11:43:22 MST DEBUG1 remoteHelperThread_1_1: inserts=61 > updates=300 deletes=55 truncates=0
Almost 2 minutes to select 416 log rows? That looks wrong. Can you change the slon configuration to have an explain_interval? With that slon will emit EXPLAIN output for the log selection query in that interval. Maybe something is screwing up the optimizer. Jan -- Anyone who trades liberty for security deserves neither liberty nor security. -- Benjamin Franklin _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
