This article discusses single-column conditions-based query optimization in PostgreSQL and talks about the table structure and query plan.
