pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedWAL and Checkpoints documentation
3+ messages / 3 participants
[nested] [flat]
* WAL and Checkpoints documentation
@ 2011-05-23 14:27 jtkells@verizon.net
2011-05-23 14:55 ` Re: WAL and Checkpoints documentation Kevin Grittner <Kevin.Grittner@wicourts.gov>
2011-05-23 17:30 ` Re: WAL and Checkpoints documentation Greg Smith <greg@2ndquadrant.com>
0 siblings, 2 replies; 3+ messages in thread
From: jtkells@verizon.net @ 2011-05-23 14:27 UTC (permalink / raw)
To: pgsql-admin
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 of any good
presentations/whitepapers that spell out WAL and check-pointing
functionality other than the ADMIN guide?
Thanking you in advance
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: WAL and Checkpoints documentation
2011-05-23 14:27 WAL and Checkpoints documentation jtkells@verizon.net
@ 2011-05-23 14:55 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
1 sibling, 0 replies; 3+ messages in thread
From: Kevin Grittner @ 2011-05-23 14:55 UTC (permalink / raw)
To: pgsql-admin; jtkells@verizon.net
<jtkells@verizon.net> 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/books/
-Kevin
[1] Full disclosure: I was one of the reviewers for this book, but
have no financial stake in its sales.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: WAL and Checkpoints documentation
2011-05-23 14:27 WAL and Checkpoints documentation jtkells@verizon.net
@ 2011-05-23 17:30 ` Greg Smith <greg@2ndquadrant.com>
1 sibling, 0 replies; 3+ messages in thread
From: Greg Smith @ 2011-05-23 17:30 UTC (permalink / raw)
To: jtkells@verizon.net; +Cc: pgsql-admin
jtkells@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 documentation into
real-world tuning advice. There are a few of my talks at
http://projects.2ndquadrant.it/talks that mention material around this
area too; "Inside the PostgreSQL Buffer Cache" and "The Write Stuff"
both overlap with checkpoint issues quite a bit. Beyond that, my book
is the main extended commentary discussing this area available.
--
Greg Smith 2ndQuadrant US greg@2ndQuadrant.com Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us
"PostgreSQL 9.0 High Performance": http://www.2ndQuadrant.com/books
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2011-05-23 17:30 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-05-23 14:27 WAL and Checkpoints documentation jtkells@verizon.net
2011-05-23 14:55 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
2011-05-23 17:30 ` Greg Smith <greg@2ndquadrant.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox