Really Big Elephants Data Warehousing with PostgreSQL
http://pgexperts.com/document.html?id=49 Presentation by Josh Berkus (PostgeSQL developer) at MySQL User Conference 2011
http://pgexperts.com/document.html?id=49 Presentation by Josh Berkus (PostgeSQL developer) at MySQL User Conference 2011
http://pgexperts.com/document.html?id=49 Presentation by Josh Berkus (PostgeSQL developer) at MySQL User Conference 2011
http://www.mysqlperformanceblog.com/2011/02/03/how-innodb-handles-redo-logging/
http://www.mysqlperformanceblog.com/2011/02/03/how-innodb-handles-redo-logging/ How MySQL InnoDB implements transaction log, aka REDO (Oracle), aka WAL (PostgreSQL)
http://sqlserverpedia.com/wiki/Understanding_the_StackOverflow_Database_Schema Notes about schema used by StackOverflow.com and related websites. It is very simple, only several tables used. (most likely because there are performance problems with joins)
http://www.codeproject.com/cs/database/persisting_trees.asp