aboutsummaryrefslogtreecommitdiff
path: root/src/bin/scripts/common.c
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2007-12-08 21:05:11 +0000
committerTom Lane <tgl@sss.pgh.pa.us>2007-12-08 21:05:11 +0000
commit9fd88436470482fc030d4c2328977b3cf66f01f1 (patch)
tree129da1e991a90cd249a97332473f8f8cc849e19e /src/bin/scripts/common.c
parent88216128546ffef136189fab9e02bae299ed406d (diff)
downloadpostgresql-9fd88436470482fc030d4c2328977b3cf66f01f1.tar.gz
postgresql-9fd88436470482fc030d4c2328977b3cf66f01f1.zip
Fix mergejoin cost estimation so that we consider the statistical ranges of
the two join variables at both ends: not only trailing rows that need not be scanned because there cannot be a match on the other side, but initial rows that will be scanned without possibly having a match. This allows a more realistic estimate of startup cost to be made, per recent pgsql-performance discussion. In passing, fix a couple of bugs that had crept into mergejoinscansel: it was not quite up to speed for the task of estimating descending-order scans, which is a new requirement in 8.3.
Diffstat (limited to 'src/bin/scripts/common.c')
0 files changed, 0 insertions, 0 deletions