Tech preview: How PostgreSQL 12 handles prepared plans
Get the chance to control the behavior of the PostgreSQL optimizer | Handling Prepared plans in PostgreSQL 12
PostgreSQL v12 new feature: optimizer support for functions
by
Laurenz Albe |
05.2019 PostgreSQL commit 74dfe58a5927b22c744b29534e67bfdd203ac028 has added “support functions”. This exciting new functionality that allows the optimizer some insight into functions. […]
PostgreSQL performance: How the optimizer handles views
How does the PostgreSQL optimizer handle views? Are views good or bad? Write better and faster code, improve performance.
Join pruning - Cool stuff in PostgreSQL
UPDATED 2023: Find out how the PostgreSQL optimizer decides about “join pruning”. Improve performance, provide end users with simpler plans.