Mohankumar Saraswatipura (Mohan) is an IBM Gold Consultant (https://www.ibm.com/gold-consultants) and an IBM Champion (https://developer.ibm.com/champions) works as a Database Solutions Architect in the United States, focusing on IBM Db2, Linux, UNIX, and Windows solutions, SAP HANA, PostgreSQL, Oracle and Snowflake. Mohan has written dozens of technical papers for IBM developerWorks and IBM Data Magazine. He is also a published author https://www.amazon.com/10-1-Linux-Windows-Database-Administration-ebook/dp/B014OISWU8, https://www.amazon.com/IBM-11-1-Certification-Guide-administration/dp/1788626915, https://www.amazon.com/IBM-Advanced-Application-Developer-Cookbook/dp/1849683964. He is a frequent conference speaker at International Db2 Users Group (IDUG) North America, IBM Think, and Db2Night Show. He is an IBM Certified Db2 Advanced Database Administrator, Db2 Application Developer, Db2 Problem Determination Master, PostgreSQL Certified Professional, and SAP HANA 2.0 Technical Certifications. Mohan holds a Master's of Technology (M Tech) degree in Computer Science & Technology and an Executive MBA (IT) from Indian Institute of Management Calcutta.
Concurrency control is an essential aspect of database systems that deals with multiple concurrent transactions. PostgreSQL employs various techniques to ensure concurrent access to the database while maintaining data consistency using atomicity and isolation of ACID (stands for Atomicity, Consistency, Isolation and Durability – https://en.wikipedia.org/wiki/ACID) properties. Concurrency Techniques Broadly there are three concurrency techniques available … Read more