How Postgres 12 Will Handle Prepared Plans — Using the same plan for prepared queries can provide a performance boost and Postgres intelligently makes a decision as to which plan to use for queries that are executed with different parameter values. Postgres 12 will let you more explicitly control what happens, however.
Appears in lists (1)
More like this (4)
Adaptive Query Optimization for Postgres — A bit of fiddling around is required to get this...
Combined Indexes vs. Separate Indexes — A common question when it comes to designing relational databases...