Subject | Re: [firebird-support] Re: Firebird performance |
---|---|
Author | Ann W. Harrison |
Post date | 2005-10-03T19:09:15Z |
Stephen,
you'd be better off using a gfix -sweep. If I recall correctly, it
doesn't block the OAT, does the same garbage collection, and doesn't try
to write out backup file.
Regards,
Ann
> A further question though. I fixed the app but the transaction numberIn this case, where the purpose of the backup is to garbage collect,
> still seems stuck this morning but gbak is running. I would suppose
> that gbak would need to run as some sort of concurrency transaction.
> Would that cause the OAT to be stuck while the backup is running. If
> so, doesn't that get you into a catch-22. You need to run the backup,
> which is slow right now because of garbage collection but it in turn
> is causing more garbage to be generated because it causes the OAT to
> be stuck for several hours?
you'd be better off using a gfix -sweep. If I recall correctly, it
doesn't block the OAT, does the same garbage collection, and doesn't try
to write out backup file.
Regards,
Ann