PostgreSQL Semi Join, Unique-ify RHS, Materialized CTEs, and Rows Estimation
As a developer, I prefer using a WITH clause and declaring Common Table Expressions (CTE) instead of...
Tags: postgres, database, sql, optimizer