On Tue, Nov 12, 2013 at 7:09 PM, Jayadevan maymala.jayade...@gmail.comwrote:
Kevin Grittner-5 wrote
The checkpointer process is responsible for creating safe points
from which a recovery can begin; the background writer tries to
keep some pages available for re-use so that processes
Jeff Janes wrote
No. The checkpointer writes all data that was dirty as of a certain time
(the start of the checkpoint) regardless of how often it was used since
dirtied, and the background writer writes data that hasn't been used
recently, regardless of when it was first dirtied. Neither
On Thu, Nov 14, 2013 at 7:58 AM, Jayadevan maymala.jayade...@gmail.comwrote:
Jeff Janes wrote
No. The checkpointer writes all data that was dirty as of a certain time
(the start of the checkpoint) regardless of how often it was used since
dirtied, and the background writer writes data
On Tue, Nov 12, 2013 at 6:57 AM, Jayadevan M maymala.jayade...@gmail.comwrote:
Hi,
What are the real differences between the bgwriter and checkpointer
process? Both of them write data from the buffer to the data files, right?
Is it just a matter of 'when' they write?
Regards,
Jayadevan
On Tue, Nov 12, 2013 at 6:57 AM, Jayadevan M maymala.jayade...@gmail.comwrote:
Hi,
What are the real differences between the bgwriter and checkpointer
process? Both of them write data from the buffer to the data files, right?
Is it just a matter of 'when' they write?
I believe, Checkpoint
Jayadevan M maymala.jayade...@gmail.com wrote:
What are the real differences between the bgwriter and
checkpointer process? Both of them write data from the buffer to
the data files, right? Is it just a matter of 'when' they write?
The checkpointer process is responsible for creating safe
Kevin Grittner-5 wrote
The checkpointer process is responsible for creating safe points
from which a recovery can begin; the background writer tries to
keep some pages available for re-use so that processes running
queries don't need to wait for page writes in order to have free
spots to use
Hi,
What are the real differences between the bgwriter and checkpointer
process? Both of them write data from the buffer to the data files, right?
Is it just a matter of 'when' they write?
Regards,
Jayadevan