Understanding PSQL's MVCC
PostgresSQL implements something called MVCC. Which alleviates the need for a Read-Lock in many cases. However when Glenn Franxman and I were trying to figure out how this works we were having trouble understanding it completely.
If you ask about MVCC in the #postgres irc channel ...