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
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 […]

No Picture
PostgreSQL Troubleshooting

How to monitor live sessions in PostgreSQL?

In PostgreSQL, you can monitor live sessions using a few different methods: You can use any of these methods to monitor live sessions in PostgreSQL, depending on your needs and the resources available to you. […]

No Picture
PostgreSQL Internals

How to use Hash Joins in PostgreSQL?

In PostgreSQL, hash joins are used to join two tables based on a join condition that involves equality comparisons. The optimizer automatically chooses this join method if it determines that a hash join would be […]