Hi Alexander !

> >
> > Once a db has been swept, and provided there is no other connection
> to the
> > database. Shouldn't subsequent SWEEPs be almost instantaneous ?
> >
> > If "yes", what could cause my subsequent SWEEPs still to take a lot
> of time
> > ? (don't know if it's as much or less than the first SWEEP though)
>
> Jerome, what is "a lot of time"? If not few minutes - most probably
> condition this mean there was not other connection and long ago
> started within it write transaction was not provided. Main task for
> sweep is to move Oldest Transaction, collection of garbage freed in
> this process is secondary effect. Check gstat -h after sweep and if it
> differs from Next more than a few ones, my guess is right.

Not sure I got you completely. My OT NT move along nicely. In this
particular case, NT equalled OT + 1 right from the first sweep.
By a "lot a of time", I mean about 10 minutes (to compare to the 8 minutes
needed for count(*) on the main table)

Reading other replies to my posts, all seems to be "normal".

I guess it's the first time I'm dealing with a db of that size ( about 9Gb,
biggest table is about 50 records big and will certainly double when my
import will be finished) and that I'll have to be prepared to some side
effects preventing me from issuing "some" actions without thinking twice.
;-)

Thanks.

--
Jerome