Webinar: Being Committed - A Review of Transaction Control Statements
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. We will discover this feature in three sessions.
Wed, 22 July 2020 at 4pm UTC
The first session will cover the following topics:
- Transactions and Persistence: Group multiple changes in a single unit
- Application Retries: Cooperation improves performance and reliability
- Transactions and Visibility: How a read/write session interacts with a read-only session
Wed, 29 July 2020 at 4pm UTC
The second session will cover the following topics:
- 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
Wed, 5 August 2020 at 4pm UTC
The third session will cover the following topics:
- Transactions and Locking: Improve transaction flow by reducing contention
- The Blind Spot of In-Flight Commit: Recover after failing at the worst time
- Commit-At-Most-Once: Recover after failing at the worst time, and in the worst way
Head of Professional Services at 2ndQuadrant
Gianni is a PostgreSQL consultant, trainer, and has been a speaker at many PostgreSQL conferences in Europe and abroad over the last 10 years. He has a PhD in Mathematics from the University of Florence. He has worked with free and open source software since the 1990s and is active in the community (Prato Linux User Group and Italian PostgreSQL Users Group). His other interests include music, drama, poetry, and athletics.
Know someone who would be interested in attending? Share the webinar with them!