Subject Re: [firebird-support] Why not sweeping?
Author Dmitry Kuzmenko
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,