Re: use_remote_estimate usage for join pushdown in postgres_fdw - Mailing list pgsql-hackers

From Tom Lane
Subject Re: use_remote_estimate usage for join pushdown in postgres_fdw
Date
Msg-id 24499.1450289492@sss.pgh.pa.us
Whole thread Raw
In response to Re: use_remote_estimate usage for join pushdown in postgres_fdw  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: use_remote_estimate usage for join pushdown in postgres_fdw  (Robert Haas <robertmhaas@gmail.com>)
Re: use_remote_estimate usage for join pushdown in postgres_fdw  (Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>)
List pgsql-hackers
Robert Haas <robertmhaas@gmail.com> 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 should be.)

Another option that should be considered is that joins should pay
attention only to the server-level setting and not to the individual
tables' settings.  This would surely be cheaper to implement, and
it avoids any questions about whether to OR or AND the individual
settings.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: checkpointer continuous flushing
Next
From: Robert Haas
Date:
Subject: Re: Tab-comletion for RLS