aboutsummaryrefslogtreecommitdiff
path: root/contrib/postgres_fdw/sql/postgres_fdw.sql
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2013-02-22 10:56:06 -0500
committerTom Lane <tgl@sss.pgh.pa.us>2013-02-22 10:56:36 -0500
commitc0c6acdfa055b0c76ea0d1defd4c2c0d5a5c256f (patch)
tree15fa0aeeb52be2d508ce2dfda25a6963924882cf /contrib/postgres_fdw/sql/postgres_fdw.sql
parentaf0a4c5924061869ee3db391900ab745107c966f (diff)
downloadpostgresql-c0c6acdfa055b0c76ea0d1defd4c2c0d5a5c256f.tar.gz
postgresql-c0c6acdfa055b0c76ea0d1defd4c2c0d5a5c256f.zip
Fix some planning oversights in postgres_fdw.
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.
Diffstat (limited to 'contrib/postgres_fdw/sql/postgres_fdw.sql')
0 files changed, 0 insertions, 0 deletions