Re: [GENERAL] Theory question

2013-11-13 Thread Jayadevan M
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 >

Re: [GENERAL] Theory question

2013-11-13 Thread Jayadevan
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

Re: [GENERAL] Theory question

2013-11-13 Thread Jeff Janes
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

Re: [GENERAL] Theory question

2013-11-12 Thread Jayadevan
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

Re: [GENERAL] Theory question

2013-11-12 Thread Kevin Grittner
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

Re: [GENERAL] Theory question

2013-11-12 Thread dinesh kumar
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

Re: [GENERAL] Theory question

2013-11-12 Thread Raghavendra
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

[GENERAL] Theory question

2013-11-11 Thread Jayadevan M
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

Re: [GENERAL] Theory

2004-10-27 Thread Thomas Hallgren
Mayra, I need info on the caracteristics of object relational databases and their advantages as well as disdvantages in comparison to relational databases and OO Databases! Please explain these chacteristics with respect to what Postgresql can and cannot do. Thanks for your assistance. With

[GENERAL] Theory

2004-10-26 Thread mayra
 hi, I need info on the caracteristics of objectrelational databases and their advantages as well as disdvantages in comparison to relational databases and OO Databases!  Please explain these chacteristics with respect to what Postgresql can and cannot do.   Thanks for your assistance. 

Re: [GENERAL] Theory!!

2004-10-26 Thread Jeff Davis
> can anyone give me some info on the caracteristics of object > relational databases and their advantages as well as disdvantages! First, it's best to understand the real concepts behind relational databases. I read two great books that taught me a lot about the theory of RDBMSs, and why they wer

Re: [GENERAL] Theory!!

2004-10-26 Thread Richard Huxton
Mayra wrote: hi, can anyone give me some info on the caracteristics of object relational databases and their advantages as well as disdvantages! I'm not sure that there is any standard definition of "object relational databases". You also don't say what you want to compare them to. Could you prov

[GENERAL] Theory!!

2004-10-25 Thread Mayra
hi,   can anyone give me some info on the caracteristics of object relational databases and their advantages as well as disdvantages!     thanx in advance.