Hemanshu Sethi
Software Developer Engineer 2
Hemanshu is a software developer from India living in Bangalore. He did his Bachelors in Computer Science and Masters in Mathematics from BITS Pilani. He has keen interests in designing complex data intensive systems. Sometimes like to solve algorithimic problems on DS/Algo. Apart from work he enjoys living an active lifestyle that includes running and working out.
Hemanshu has worked at Sixt since 2021, working with fleet teams(FADMIN & FSALES).
Posts by Hemanshu Sethi:
PostgreSQL: A simplified guide to locking concepts
Recently, I have experienced certain problems while executing multiple transactions concurrently on top of Postgres while working on my everyday tasks in SIXT. This persuaded me to write this blog. While Postgres is amazing at running multiple transactions at the same time, there are a few cases in which Postgres need to block a transaction using a lock. One has to be careful about which locks a transaction should acquire and the high-level abstractions provided by Postgres are difficult to understand. With this Blog, I will try to demystify the locking behaviours in Postgres and give advice on common issues faced.
PostgreSQL has amazing support for executing complex, concurrent and ACID transactions. To make sure that concurrent/complex transactions run perfectly Postgres uses several layers of locks to serialise changes to critical sections of the database.
read more