Subject Re: GBAK.EXE consume lot of physical RAM if backup a big database
Author Adam
--- In, "Chau Chee Yang" <ccy@...> wrote:
> Hi,
> I backup a firebird database with GBAK.EXE with the following options:
> gbak -b -v ACC-0007.FDB c:\temp\a.gbk
> The Size of ACC-0007.FDB is about 800M and the a.gbk size is about 500M.
> When gbak is running, I open "Windows Task Manager" and notice how the
> Physical RAM is use. It happens that the physical RAM keep decrease
> while the backup is running. When the backup is going to finish, it
> has consume about 500M.
> When GBAK.EXE finish running, the RAM is release and back to normal.
> Is this the way of how the GBAK.EXE works? It seems like this is a
> good design or there are switches in GBAK to turn this behavior off?
> I am using Firebird 1.5.3 on Windows XP Professional.
> Thank you.
> Best Regards,
> Chau Chee Yang

Which process is taking up this 500MB? Gbak, FBServer or
FB_INET_SERVER? Maybe use Sysinternals process explorer instead of
task manager for more information.

Also, you do realise that Windows doesn't do its memory cleanup the
moment you free the memory? Cleanup happens if Windows realises it
runs out of memory or it has enough idle time to do so.