Thread: sharp or fuzzy checkpoint?

sharp or fuzzy checkpoint?

From
Tatsuo Ishii
Date:
I'm interested in point-in-time-recovery (or archive recovery) too.
I'm wondering current implementation of CHECKPOINT is whether "SHARP"
or "FUZZY" checkopint. If it's a "SHARP" one, it would be a serious
performance bottle neck according to the Gray's transaction book. Does
anybody know anything about that?
--
Tatsuo Ishii


Re: sharp or fuzzy checkpoint?

From
Bruce Momjian
Date:
Tatsuo Ishii wrote:
> I'm interested in point-in-time-recovery (or archive recovery) too.
> I'm wondering current implementation of CHECKPOINT is whether "SHARP"
> or "FUZZY" checkopint. If it's a "SHARP" one, it would be a serious
> performance bottle neck according to the Gray's transaction book. Does
> anybody know anything about that?

We have a FUZZY checkpoint because we continue processing during
the checkpoint period.  In fact, we can add WAL files during the
checkpoint activity.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026