Re: [GENERAL] Need help understanding WAL and checkpoints

2013-02-07 Thread drew_hunt1976
Hi Albe --- On Wed, 2013/2/6, Albe Laurenz wrote: > drew_hunt wrote: > > I'm trying to get my head around WAL and checkpoints and need to ask a > > couple of questions before I > > get a headache. > > > > Firstly, I see the terms "WAL log", "WAL file" and "transaction log" all > > over the pl

[GENERAL] Need help understanding WAL and checkpoints

2013-02-06 Thread drew_hunt1976
Hi there I'm trying to get my head around WAL and checkpoints and need to ask a couple of questions before I get a headache. Firstly, I see the terms "WAL log", "WAL file" and "transaction log" all over the place - are these the same thing (i.e. files in the pg_xlog directory)? I'm a bit confu