Thu Sep 28 12:12:55 PDT 2006
- Previous message: [Slony1-general] where does primary key info get stored?
- Next message: [Slony1-general] cleanup thread frequency
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Previous message: [Slony1-general] where does primary key info get stored?
- Next message: [Slony1-general] cleanup thread frequency
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list