Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
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.
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.