Richard Yen dba
Thu Sep 28 12:12:55 PDT 2006
Looking at my logs, the cleanupThread runs about once every 11  
minutes, and the vacuuming takes anywhere from 90s to 200s to finish.

My slon_conf_vac_frequency is set at 1, so I can't make the vacuums  
finish any faster.

Sample cleanupThread output:

2006-09-28 10:50:52 PDT DEBUG1 cleanupThread:    0.011 seconds for  
cleanupEvent()
2006-09-28 10:50:52 PDT DEBUG1 cleanupThread:    0.076 seconds for  
delete logs
2006-09-28 10:50:52 PDT DEBUG3 cleanupThread: minxid: 270375864
2006-09-28 10:52:29 PDT DEBUG2 cleanupThread:   96.742 seconds for  
vacuuming
2006-09-28 11:04:25 PDT DEBUG1 cleanupThread:    0.030 seconds for  
cleanupEvent()
2006-09-28 11:04:26 PDT DEBUG1 cleanupThread:    0.338 seconds for  
delete logs
2006-09-28 11:04:26 PDT DEBUG3 cleanupThread: minxid: 270545819
2006-09-28 11:06:12 PDT DEBUG2 cleanupThread:  106.322 seconds for  
vacuuming
2006-09-28 11:18:14 PDT DEBUG1 cleanupThread:    0.011 seconds for  
cleanupEvent()
2006-09-28 11:18:14 PDT DEBUG1 cleanupThread:    0.215 seconds for  
delete logs
2006-09-28 11:18:14 PDT DEBUG3 cleanupThread: minxid: 270764233
2006-09-28 11:21:42 PDT DEBUG2 cleanupThread:  208.187 seconds for  
vacuuming
2006-09-28 11:33:36 PDT DEBUG1 cleanupThread:    0.021 seconds for  
cleanupEvent()
2006-09-28 11:33:36 PDT DEBUG1 cleanupThread:    0.319 seconds for  
delete logs
2006-09-28 11:33:36 PDT DEBUG3 cleanupThread: minxid: 270976676
2006-09-28 11:36:04 PDT DEBUG2 cleanupThread:  148.450 seconds for  
vacuuming
2006-09-28 11:48:01 PDT DEBUG1 cleanupThread:    0.010 seconds for  
cleanupEvent()
2006-09-28 11:48:01 PDT DEBUG1 cleanupThread:    0.095 seconds for  
delete logs
2006-09-28 11:48:01 PDT DEBUG3 cleanupThread: minxid: 271171171
2006-09-28 11:49:58 PDT DEBUG2 cleanupThread:  116.714 seconds for  
vacuuming
2006-09-28 12:01:58 PDT DEBUG1 cleanupThread:    0.011 seconds for  
cleanupEvent()
2006-09-28 12:01:58 PDT DEBUG1 cleanupThread:    0.496 seconds for  
delete logs
2006-09-28 12:01:58 PDT DEBUG3 cleanupThread: minxid: 271340702
2006-09-28 12:04:40 PDT DEBUG2 cleanupThread:  161.430 seconds for  
vacuuming

Since cleanupThread runs about once per 11min, is there any way to  
get the cleanupThread to run more often?

--Richard



More information about the Slony1-general mailing list