Re: use_remote_explain missing in docs of postgres_fdw

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

In response to

Browse pgsql-hackers by date

  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