On the Viability of Speculative Transactional Replication in Database Systems: A Case Study with PostgreSQL (original) (raw)

2013, 2013 IEEE 12th International Symposium on Network Computing and Applications

AI-generated Abstract

The paper investigates the feasibility of speculative transactional replication in database systems, particularly using PostgreSQL as a case study. It highlights fault tolerance as a crucial property of transactional systems and proposes active replication paired with speculative processing to enhance performance, especially in multicore architectures. The evaluation employs synthetic benchmarks and TPC-C tests, demonstrating that speculation is indeed viable, with limited overhead under concurrency control. The findings suggest that speculative processing can be effectively implemented, offering meaningful performance gains in scenarios involving non-conflicting transactions.