[firebird-support] garbage collect

2015-04-05 Thread Nick Upson n...@telensa.com [firebird-support]
Hi I'd like to do my backup without gc and then do the gc separately - is there any effective difference between doing "gbak with gc" and "gbak without gc" and then "gfix -sweep" Nick Upson, Telensa Ltd, Senior Operations Network Engineer direct +44 (0) 1799 533252, support hotline +44 (0) 179

Re: [firebird-support] garbage collect

2015-04-05 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
> On Apr 5, 2015, at 11:23 AM, Nick Upson n...@telensa.com [firebird-support] > wrote: > > > is there any effective difference between doing "gbak with gc" and > "gbak without gc" and then "gfix -sweep" The only differences (that I can think of) are caused by concurrent actions. If you garb

Re: [firebird-support] garbage collect

2015-04-09 Thread Thomas Steinmaurer t...@iblogmanager.com [firebird-support]
> great thanks > > to make sure I've got this right > > starting with the same database I can do either > > a) gbak with gc > > b) gbak without gc and gfix -sweep > > and I will have the same final result > > > Extending this further, how can identify which tables contain (or did > contain) the gar

Re: [firebird-support] garbage collect

2015-04-09 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
> On Apr 9, 2015, at 11:01 AM, Nick Upson n...@telensa.com [firebird-support] > wrote: > > to make sure I've got this right Not quite. > > starting with the same database I can do either > > a) gbak with gc Won't advance the oldest active > > b) gbak without gc and gfix -sweep Will move

Re: [firebird-support] garbage collect

2015-04-09 Thread Nick Upson n...@telensa.com [firebird-support]
great thanks to make sure I've got this right starting with the same database I can do either a) gbak with gc b) gbak without gc and gfix -sweep and I will have the same final result Extending this further, how can identify which tables contain (or did contain) the garbage. As well as handl