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

No Picture
PostgreSQL Internals

Optimizer index caching in PostgreSQL

Optimizer index caching in PostgreSQL is the process by which the database caches the index pages in memory to speed up the execution of queries. This feature helps improve the performance of queries by reducing […]

No Picture
PostgreSQL Internals

PostgreSQL Mutex tips and techniques

Mutexes (short for mutual exclusion) are used in PostgreSQL to ensure that only one thread of execution can access a shared resource at any given time. Here are some tips and techniques for working with […]