The PostgreSQL docs, and source code, are an absolute shining star, in Open Source or otherwise. I'm hard pressed to think of a project that does it better, really.