Re: Checkpoint Question - need feedback

hello Madison, one more thing people sometimes use onmode -B followed by onmode -c to reduce checkpoint times....i guess you know that; however you may want to look at that too. Superboer Superboer schreef: > Hello Madison, > > sorry have not looked for it yet.... > what is the max size for the phys log nowadays; it used to be 2 GB > eq the size of a chunk....that is i guess to small. > > > So - basic question --- Is the cost of the increased physical log file > > (maybe 3-4 times larger in some cases) totally outweigh the benefit of > > non-blocking checkpoints? > > Yes. > > however if one is loading a truck load of data, page cleaners may not > keep > up at all. In such a case blocking checkpoint may be welcome. > or generate our own checkpoint whenever the buffer cache is 75% dirty > start a checkpoint which does big buffer writes... > > i rather run a checkpoint when the buffer cache is 75 % dirty then when > the phys > log is 75% full; at least resources are used the best way and i have > some control > over it and most important, it's fast... > > So do not take them away completely please. > > See you > > Superboer.