Kelly implemented reporting and history-tracking extensions in Postgres. It keeps track of any changes to the system. This has been valuable in letting clients know what happened to their data, where bugs were happening in the system and generally saving our butts. The reporting system takes changes made in a attribute style table structure and arranges them in a standard table type structure for reporting. Kelly will explain why this system was built and how, including limitations of Postgres that had to be accommodated, and an introduction to writin
Learn how MVCC really works, why it's the best thing since sliced bread for concurrent read/write activity, and why it blows the locking approach out of the water. We'll focus on the way MVCC is implemented in Postgres, but the underlying concepts apply to all MVCC-based databases.
For users and developers.
Greg Sabino Mullane is a noted contributor to Postgres.