Files
zeekayandHanzo Dev 1e6c033729 zap_fdw: each worker keeps the plans of the statements it runs
A request was planned anew every time. Against an entity table with a
partial index per indexed field, planning cost more than running: 2.3 ms
against 0.2 ms for a user lookup. Statements name their kind as a literal
and bind their values, so one shape plans once per worker. PostgreSQL
invalidates a kept plan when the table's indexes or definition change. The
cache holds 1024 statements per worker and starts over past that.

Co-authored-by: Hanzo Dev <[email protected]>
2026-10-02 16:57:10 -07:00
..