Articles by Shiv Iyer

About Shiv Iyer
Open Source Database Systems Engineer with a deep understanding of Optimizer Internals, Performance Engineering, Scalability and Data SRE. Shiv currently is the Founder, Investor, Board Member and CEO of multiple Database Systems Infrastructure Operations companies in the Transaction Processing Computing and ColumnStores ecosystem. He is also a frequent speaker in open source software conferences globally.
Website Facebook Twitter LinkedIn
No Picture
PostgreSQL Internals

What does a COMMIT do internally to PostgreSQL?

In PostgreSQL, a COMMIT statement is used to finalize a transaction and make its changes permanent in the database. When a COMMIT statement is executed, the following things happen internally in PostgreSQL: After a transaction […]
No Picture
MinervaDB

Why SELECT * from is bad for SQL performance?

Using SELECT * can be bad for SQL performance for several reasons, including the following: Overall, it is best practice to only select the columns that are needed for a query, rather than using SELECT […]
No Picture
PostgreSQL Internals

How Latches are implemented in PostgreSQL?

PostgreSQL uses latches to provide synchronization between different threads accessing shared resources. Latches are lightweight and efficient mechanisms that provide mutual exclusion between threads. Here is a table describing all the PostgreSQL latches, their purpose, […]
No Picture
PostgreSQL Performance

How to implement parallel queries in PostgreSQL 15?

PostgreSQL 15 introduces a new parallel query feature called “Partitionwise Joins” which can improve the performance of queries involving large tables. Here’s how to implement parallel queries using this feature: Here’s an example query that […]