Subject Re: [firebird-support] What regular maintenance actions does Firebird need in order to function properly?
Author Javier Cintron
So, these are the maintenance actions that I am going to perform every night(I have a gap between 1am and 7 am): 

  1. In the main server
    1. Backup using gbak. 
    2. Restart o of the database to get rid of long transactions
    3. Sweep.
  2. In the backup server
    1. Restore of the database using gbak.  
    2. Check the return code of gbak and if it is different from zero there is a problem with the database. 

And every week: 

  1. Recalculate index statistics. 

What do you think? These actions are enough? Would you change something?

thanks in advance for your kind help. 

On Friday, May 4, 2018, 11:08:47 AM CDT, Javier Cintron fcintrono@... [firebird-support] <> wrote:


What I mean is this: I want to know if a need to increment the page cache buffer of Firebird.

And If was thinking of having some metric to measure it. 

This metric would be very convinient If I need for example to justify buying more memory for the server.

Thanks in advance.