On Thu, Nov 14, 2013 at 7:58 AM, Jayadevan wrote:
> 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
>
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 Tue, Nov 12, 2013 at 7:09 PM, Jayadevan wrote:
> 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 n
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
Jayadevan M 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 points
from which a recovery
On Tue, Nov 12, 2013 at 6:57 AM, Jayadevan M wrote:
> 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" is one of the responsi
On Tue, Nov 12, 2013 at 6:57 AM, Jayadevan M wrote:
> 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
>
Expect some corrections
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
