Subject Re: [firebird-support] Forced write, page size and buffer size
Author Aldo Caruso

  thanks for your answer.


El 18/08/14 a las 15:59, 'Leyne, Sean' Sean@... [firebird-support] escibiĆ³:

> Given this scenario my questions are the following:
> 1) Does it makes sense to activate forced writes on Linux ?

Different versions of Linux file systems provide better protection than others.

Personally, I believe that forced write = ON is necessary for all OS -- but I suspect that I am in the minority (some will swear they have never had a problem/db corruption, but I am too chicken to take the risk -- I like sleeping at night).

> 2) Is increasing the page size the right approach to improve performance ?
> Which are the drawbacks of setting page size to 16K ?

There is no universally true answer, it depends.

> 3) The same question stands for cache pages: is it useful ( or has
> disadvantages ) to have so many cache pages as there are on disk pages (
> provided there is enough RAM size ) ?

As long as you have the RAM there is no problem.