Subject | Re: [firebird-support] Re: sweep taking a long time |
---|---|
Author | Nando Dessena |
Post date | 2005-11-10T13:33:52Z |
Sándor,
S> And what happens to the OLD database, if I let FB to do the garbage
S> collection?
it will be garbage-collected as a result of gbak visiting all records in
the database. This has a good effect on performance since it frees
pages for reuse and reduces the number of record back-versions.
S> Because I had a corrupt database, which I could not back up. (it stopped
S> backup with error messages). Then I instinctly turned off garbage
S> collection, and FB did a corerct backup, which I can the restore. The DB
S> have been working correctly since then.
I am not an expert in this area, and anyway without seeing what error
messages you got it is difficult to guess.
Ciao
--
Nando Dessena
======================================================
I support Firebird, I am a Firebird Foundation member!
Join today at http://www.firebirdsql.org/ff/foundation
======================================================
S> And what happens to the OLD database, if I let FB to do the garbage
S> collection?
it will be garbage-collected as a result of gbak visiting all records in
the database. This has a good effect on performance since it frees
pages for reuse and reduces the number of record back-versions.
S> Because I had a corrupt database, which I could not back up. (it stopped
S> backup with error messages). Then I instinctly turned off garbage
S> collection, and FB did a corerct backup, which I can the restore. The DB
S> have been working correctly since then.
I am not an expert in this area, and anyway without seeing what error
messages you got it is difficult to guess.
Ciao
--
Nando Dessena
======================================================
I support Firebird, I am a Firebird Foundation member!
Join today at http://www.firebirdsql.org/ff/foundation
======================================================