Hello, fdt4y! Tuesday, July 10, 2012, 1:31:23 PM, you wrote:
f> What are we overlooking? Our only current solution is to do a f> full backup and restore at silly morning hours, otherwise the system grows terribly slow f> due to garbage not being collected. f> Oldest transaction 460 f> Oldest active 461 f> Oldest snapshot 461 f> Next transaction 50325450 you overlooking that some of your applications started transaction long time ago (50 million transactions, 7 days ago), and this transaction is still ACTIVE. That's why versions still not garbage, and that's why sweeping does not "help". -- Dmitry Kuzmenko, www.ib-aid.com