Re: [ADMIN] WAL and Checkpoints documentation

2011-05-23 Thread Greg Smith
jtke...@verizon.net wrote: Does anyone know of any good presentations/whitepapers that spell out WAL and check-pointing functionality other than the ADMIN guide http://www.westnet.com/~gsmith/content/postgresql/chkp-bgw-83.htm is the main free reference that tries to step outside of the docum

Re: [ADMIN] WAL and Checkpoints documentation

2011-05-23 Thread Kevin Grittner
wrote: > Does anyone know of any good presentations/whitepapers that spell > out WAL and check-pointing functionality other than the ADMIN > guide? I don't know of a better write-up than what's in chapters 5 and 6 of Greg Smith's "High Performance" book[1]: http://www.postgresql.org/docs/boo

[ADMIN] WAL and Checkpoints documentation

2011-05-23 Thread jtkells
I have been reading the POSTGRESQL System Admin Documentation 8.4 (several times) on WAL and Checkpoints along with their respected option switches. I can say that I have a general understanding of what is going on but get confused with the details and use of the option switches. Does anyone know