jtkells@xxxxxxxxxxx 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@xxxxxxxxxxxxxxx Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us "PostgreSQL 9.0 High Performance": http://www.2ndQuadrant.com/books -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
