On Sunday, 17 February 2019 20:58:47 EET Jeff Janes wrote: > A question for the PostgreSQL hackers would be, Is it necessary and > desirable that the EXPLAIN be issued in the same transaction as the > eventual DECLARE and FETCHes? I don't think it is. I guess if the foreign > side table definition got changed between EXPLAIN and DECLARE it would > cause problems, but changing the foreign side definition out of sync with > the local side can cause problems anyway, so is that important to preserve?
Won't separate transactions cause issues if the statistics of the table change in the meantime in a way that affects the plan? > Cheers, > > Jeff -- Regards, Peter
