How PostgreSQL Executes Queries
Interview Questions
- What happens internally when PostgreSQL receives a SQL query?
- What is the query planner?
- What is the difference between a Sequential Scan and Index Scan?
- What is a Bitmap Heap Scan?
- Why might PostgreSQL choose a Sequential Scan even when an index exists?
- What is a Nested Loop Join?
- What is a Hash Join?
- What is a Merge Join?
- How does PostgreSQL decide which JOIN strategy to use?
- How would you investigate a slow query?
Next TopicIndex Basics