Hello, Markus!

sc_mtnbkr@... wrote:

>
> I doubt raising the priority of sweep/garbage
> threads would yield good side effects for a
> database under heavy transaction load. It probably
> wouldn't make a difference on a single user or low
> load system.

I have already seen that low priority sweep is useless. Read my two posts
at
http://sourceforge.net/forum/forum.php?thread_id=64658&forum_id=28063

that describes the problem. 45 minutes to sweep 10K records in a single-user
environment is TOO MUCH.
Since gbak does not have option -g by default, DBA will wait forever to backup
50-60 megabytes database, if there were frequent updates and deletes.

The main hit of setting sweep tread priority to low was to prevent heavy
load during sweep, as I understand. Now low sweep priority is a head pain for DBA.

--
Dmitry Kuzmenko, Epsylon Technologies.