| From: | auxsvr <auxsvr(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: FDW, too long to run explain |
| Date: | 2019-02-17 19:43:05 |
| Message-ID: | 2614341.vqdVxeSBeF@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Janes | 2019-02-17 21:00:15 | Re: [External] Re: FDW, too long to run explain |
| Previous Message | Vijaykumar Jain | 2019-02-17 19:36:56 | Re: [External] Re: FDW, too long to run explain |