David Fetter <david@fetter.org> writes:
> On Thu, Sep 30, 2010 at 10:29:56PM -0400, Robert Haas wrote:
>> Yeah, that might be better. Is it reasonable to assume we always
>> want to push down as much as possible, or do we need to think about
>> local work vs. remote work trade-offs?
> In cases where the foreign side is not super reliable for correctness,
> I'd say there's a good case for not trusting it. Some of the Oracle
> properties are like this. I suppose we might want to make "trust the
> other side to handle pushed quals" optional somehow, but I'm not
> exactly sure how.
ISTM that such decisions would be embedded in the FDW --- it's unlikely
that the FDW for Oracle would look even a little bit like the one for
Postgres anyway, so contemplating ways to parameterize them seems a
rather useless exercise.
What we need is an API that lets the FDW decide which quals it will take
responsibility for enforcing. What happens beyond that point is not
ours to decide.
regards, tom lane