This post discusses the PostgreSQL plan_cache_mode setting and its usefulness in generating custom execution plans. It also explains how PostgreSQL uses indexes when filtering by status and introduces the force_custom_plan option.
Table of contents
IntroductionDomain ModelFiltering by statusDefault PostgreSQL plan_cache_modeUsing the force_custom_plan option of the plan_cache_modeConclusion893 Impressions