Re: [HACKERS] use_remote_estimate usage for join pushdown in postgres_fdw

On Wed, Dec 16, 2015 at 11:41 PM, Tom Lane wrote: > Robert Haas writes: > > I like option #2. I don't really have a strong reason for that, but > > it feels intuitive to me that we err on the side of using remote > > estimates when in doubt. > > If we

Re: [HACKERS] use_remote_estimate usage for join pushdown in postgres_fdw

On Fri, Dec 11, 2015 at 4:44 AM, Ashutosh Bapat wrote: > Hi All, > postgres_fdw documentation says following about use_remote_estimate > (http://www.postgresql.org/docs/devel/static/postgres-fdw.html) > -- > use_remote_estimate > This option, which can be

Re: [HACKERS] use_remote_estimate usage for join pushdown in postgres_fdw

Robert Haas writes: > I like option #2. I don't really have a strong reason for that, but > it feels intuitive to me that we err on the side of using remote > estimates when in doubt. If we believe that, why isn't the default value of use_remote_estimate true? (Maybe it

Re: [HACKERS] use_remote_estimate usage for join pushdown in postgres_fdw

On Wed, Dec 16, 2015 at 1:11 PM, Tom Lane wrote: > Robert Haas writes: >> I like option #2. I don't really have a strong reason for that, but >> it feels intuitive to me that we err on the side of using remote >> estimates when in doubt. > > If we

[HACKERS] use_remote_estimate usage for join pushdown in postgres_fdw

Hi All, postgres_fdw documentation says following about use_remote_estimate ( http://www.postgresql.org/docs/devel/static/postgres-fdw.html) -- use_remote_estimate This option, which can be specified for a foreign table or a foreign server, controls whether postgres_fdw issues remote EXPLAIN