mirror of
https://github.com/hanzoai/sql.git
synced 2026-11-15 19:38:30 +00:00
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]>