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
