4 ms·
Nothing to do with plan caching, thats just talking about plan execution of parallel operations which is that thread or process based in PG? If process based t
by SigmundA 7mo ago
Nothing to do with plan caching, thats just talking about plan execution of parallel operations which is that thread or process based in PG?
If process based then they can send small parts of plan across processes.
- hans_castorp 7mo agoAh, didn't see the caching part. Plans for prepared statements are cached though.
- AlisdairO 7mo agoOnly on a per-connection basis
- SigmundA 7mo agoYes if the client manually prepares the statement it will be cached for just that connection because in PG a connection is a process, but it won't survive from one connection to the next even in same process. Other databases like MSSQL have prepared statements but they are rarely used now days since plan caching based on query text was introduced decades ago.