>
> > oooooh, sweep every night eh? suck it in every night - blow it out every
> > day... seems like a waste of time to me. Let your databse server manage
> it's
> > own space requirements, i'll use what it's created very efficiently.
>
> How will space be reused if no GC ever happen ?
> Also, if I let garbage growing and growing, isn't there a risk for a
> connection to get "hit" one day by a big GC task ?
> I always thought one should be careful with bulk deletes, that's why I'm
> asking.
>
> Regards.
>
> --
> Jerome
>

if you are moving your transactions ahead, you'll never be hit by the 20,000
gap (default seep). In any case, I turn it off by default. But even if I
didn;t my application would never trigger it even if I let them go for 10
years without maintenance. Remember the 20,000 is not a transaction count,
it's a gap between active and next.
Alan