4 ms·
That doesn't say anything about named vs unnamed. This does though: "If successfully created, a named prepared-statement object lasts till the end of the curre
by chasers 3y ago
That doesn't say anything about named vs unnamed. This does though:
"If successfully created, a named prepared-statement object lasts till the end of the current session, unless explicitly destroyed. An unnamed prepared statement lasts only until the next Parse statement specifying the unnamed statement as destination is issued."
https://www.postgresql.org/docs/current/protocol-flow.html#PROTOCOL-FLOW-EXT-QUERY https://www.postgresql.org/docs/current/protocol-flow.html#P...
- phamilton 3y agoAh, that makes sense. Conclusion: I still want named prepared statements to take advantage of generic plans.