| Subject | Re: [firebird-support] Sweep Interval and Garbage Collection |
|---|---|
| Author | Ann W. Harrison |
| Post date | 2006-03-24T22:19:27Z |
Jason Dodson wrote:
with gfix, the services API, or a special dpb in an attach call. The
new setting will take effect when ... probably when the last old
connection exits, but I'm not entirely sure. New connections will see
the new value, and there are locks to keep two sweeps from happening
concurrently.
Garbage collection can be disabled on a transaction-by-transaction
basis. It's an option on the tpb of a start_transaction call. Don't do
it without a very good reason, since garbage postponed is garbage fermented.
Cheers,
Ann
> I know the sweep interval is tunable, but I am unsure as to where. Also, I got the impression some time ago that garbageThe sweep interval is stored in the database header page and updated
> collection could be turned off... was I dreaming?
>
with gfix, the services API, or a special dpb in an attach call. The
new setting will take effect when ... probably when the last old
connection exits, but I'm not entirely sure. New connections will see
the new value, and there are locks to keep two sweeps from happening
concurrently.
Garbage collection can be disabled on a transaction-by-transaction
basis. It's an option on the tpb of a start_transaction call. Don't do
it without a very good reason, since garbage postponed is garbage fermented.
Cheers,
Ann