Remix.run Logo
SigmundA 6 hours 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 6 hours ago | parent [-]

Ah, didn't see the caching part.

Plans for prepared statements are cached though.

SigmundA 2 hours ago | parent | next [-]

Yes 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.

AlisdairO 3 hours ago | parent | prev [-]

Only on a per-connection basis