Kellyn Gorman continues a series on PostgreSQL for Oracle DBAs:
As an Oracle DBA venturing into the world of PostgreSQL, one of the most important areas to get comfortable with is performance tuning. While Oracle’s Cost-Based Optimizer (CBO) is a well-known powerhouse that many DBAs have learned to both respect and wrestle with, PostgreSQL offers its own sophisticated query planner that behaves differently. Understanding these differences is key to becoming proficient with PostgreSQL as we step into tuning.
Read on to gain an overview of what options are available on the PostgreSQL side and how they differ from what’s available in Oracle.