From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com> |
Cc: | PostgreSQL mailing lists <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: use_remote_explain missing in docs of postgres_fdw |
Date: | 2013-02-22 14:01:17 |
Message-ID: | 27770.1361541677@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Michael Paquier <michael(dot)paquier(at)gmail(dot)com> writes:
> On Fri, Feb 22, 2013 at 5:13 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> Wups ... for some reason it's "use_remote_estimate" in the docs. Thinko
>> on my part probably --- although on reflection, maybe that's a better
>> name anyway?
> Indeed, use_remote_estimate is better. use_remote_explain makes it sound
> like an EXPLAIN query would be sent to remote server. That is at least the
> first impression I had when testing the feature without reading the docs.
Well, it does do that, at least for the part of the query that will be
executed on the remote server. But if you read it to mean the whole
query would be EXPLAINed on the remote server, that's wrong.
The objection I have to "use_remote_explain" is that it's focusing too
much on the mechanism (ie, send an EXPLAIN command for execution) rather
than the result (ie, get a cost estimate from the remote server).
So I'm inclined to change the code to match the docs rather than vice
versa. Anyone have a contrary opinion?
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2013-02-22 14:10:42 | Re: FDW for PostgreSQL |
Previous Message | Thom Brown | 2013-02-22 13:59:18 | Re: FDW for PostgreSQL |