• Tom Lane's avatar
    Fix some planning oversights in postgres_fdw. · c0c6acdf
    Tom Lane authored
    Include eval costs of local conditions in remote-estimate mode, and don't
    assume the remote eval cost is zero in local-estimate mode.  (The best
    we can do with that at the moment is to assume a seqscan, which may well
    be wildly pessimistic ... but zero won't do at all.)
    
    To get a reasonable local estimate, we need to know the relpages count
    for the remote rel, so improve the ANALYZE code to fetch that rather
    than just setting the foreign table's relpages field to zero.
    c0c6acdf
postgres_fdw.c 42.6 KB