Through the Planet PostgreQL site I found a nice paper that compares database internals. It provides an interesting read, even if you are not really into databases.
Architecture of a Database System
Joseph M. Hellerstein, Michael Stonebraker and James Hamilton