PostgreSQL offers many advanced features that applications can use to store information reliably and efficiently for the longer term. One such feature is the ability to control transactions.
In the second session of this three-part webinar, the following topics were covered:
- Replicated Transactions: Replication can provide extra reliability, if properly used.
- Performance Expectations: Will transactions make my database faster/slower?
- Hidden Costs of Transactions: Multi-Version Concurrency Control, Vacuum, Freezing